>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.
>
>Thanks,
>
>Yossi


I don't know why this works, but I received a tip several years ago that sometimes cleans this up.

SET TABLEVALIDATE TO 0
USE myTable
GO BOTT
BROWSE

Manually append 4 or 5 records (I use CTRL-Y in the browse window) and then DELETE the newly appended records.

It doesn't work all the time, but it works frequently enough to be worth a try.

.........Rich