>I tried the fix_dbf program written by Ken Harrison
>When running throught the dbfs, it corrected the bad one but another one has lost some record so I am a bit afraid to use it in real life.
>
>Any suggestion for a fix?
>
>Thanks
>Eric.

Run the fix on a copy of the corrupted table [copy the .FPT file also if one exists]. Then look at the data in the recovered table. I do not think there is any guarantee from any table repair product that ALL records will be recovered. One of the ways a table becomes corrupt is the record count. These products will set this record count to what is in the table. But if the table became corrupt as users were inserting new records, those records will probably be lost even though the data may be there. This is similar to the DOS error of file size is being reported incorrectly or some other such FAT message. Then DOS fixed the file by resetting the eof marker. Any data beyond that marker was then erased.