>>Hi All:
>>
>>On a USE, I'm getting the following message:
>>
>>
>>Table 'Foo.dbf' has become corrupted. The table will have to be repaired before using again.
>>
>>
>>When I run a program (SBT) that uses this table, the system crashes with the following message:
>>
>>
>>Table 'Foo.dbf' has a file length/record count inconsistency. The table will need to be rapaired before transactions can be committed properly.
>>
>>
>>My question is: Is there a way to repair the table without having to restore from a backup? Note that this table is part of a .DBC database.
>
>Does SBT have any sort of repair function built-in?
>
>If you go to the UT home page, click on the "Downloads" link, and search on "Repair" there are several free downloads that may work for you. Before trying any repair utility I'd make a backup of all the SBT data files/DBCs etc. Consider trying repair utilities on a copy of the original data.
>
>More possibilities at
http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools~Wiki .
>
>Before trying any repairs you might want to check the System or Application Event Logs for any disk-related errors, in case a failing disk is to blame.
>
>You can also Google [dbf repair], you'll probably find there are paid and free options. Years ago when I last looked at them some of the "free" ones would repair only the first 50 or so rows of a data file, if your table was larger you had to buy a paid version. Maybe things are different today.
Al,
Thanks for all the info. I'll look into all the options.