Hi,

Thank for your advise. however, just like to know more on SDT.
Is it able to automatically fix my corrupted dbf,DBC and index file. Plus make it a ease to update my new dbf file stucture to my customer site.
BTW, can you recommend any stand alone tool like foxbase which we use to view, edit our customer vfp3-5 dbf file at their site. Becoz, sometime, our tech guy need to check out the dbf file at our customer site.

Thank you.

>>Hi,
>>
>>I am looking for a program that hopefully meet these requirement
>>
>>1) able to fix any corruption to dbf,memo, and index, CDX and DBC
>>2) able to had solid data dictionary features
>>3) able to keep a log file like sql Server do, so that any corruption, I can roll back the old data
>>4) able to do sychronize database between two place like sql server
>>
>>Any one know/recommend of any good library that can integrate with vfp 5 or visual basic 5 to do the above features.
>>I heard that Stonefield database toolkit and Foxaudit are able to do what I am looking for. Any one had used them before, please comments on the con and pro of using them.
>>Thank you.
>
>I use Stonefield and am very pleased with it. AFAIK, SDT will not do your requirement #3. But VFP has Transaction/EndTransaction capability. You have to develop your own code to trap table updates that you want to rollback for particular reasons -- e.g., another user has saved changes to a record right before another user tried to save changes to the same record.