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

It is able to correct many of the most common forms of data table corruption, but not all. It can repair damaged tables in some, but not all cases (it handles damaged headers quite nicely, but won't be able to do much if your table is damaged due to a disk failure, or operating system errors in allocation tables. None of the packages will without at least some level of skilled intervention.) it does a beautiful job of managing the database container; virtually all aspects or objects within the container can be repaired or recreated from data stored in spearate metadata tables, including table structures, views, indexes, relations and the like.

>Plus make it a ease to update my new dbf file stucture to my customer site.

Again, it does a great job of updating the DBC via metadata; you can ship changes to nearly any aspect of a database, and provides a means of validating the current structure against the metadata. There are limits to what it can do; it won't, for example, create a new field and populate it with unique data allowing it to serve as a primary or candidate key; you've got to write code here. Similarly, if you need to update data content, as opposed to structure, you're going to have to develop a delivery mechanism to add or alter the content of your tables in the field.

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