>>>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
>
>That seems to have worked. Thanks!
>
>One question: Are there still some gremlins lurking or does this pretty much recreate a pristine header?

Create a new table and fill with the data
Let's asume the table is not in a database and no idx files

use yourTable
copy to XYZ with cdx &&create a new table from scratch and fill
use
dele file yourTable.*
rename XYZ.dbf to yourTable.dbf
rename cdx.dbf to yourTable.cdx

use yourTable

this is more or less the same as PACK

Lutz