>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.