I downloaded CMRepair utility and ran it against my tables. It shows NO corruption. I don't know who to believe, FoxFix or CMRepair. At least with CMRepair I can sleep better <g>. But I wish VFPT would come up with a tool to check VFP tables for corruption.
>Why do you think that table is corrupted? Why do you think that header is corrupted?
>
>>I need to fix a corrupted VFP database table. I suspect that the table header is corrupted. I have a questions:
>>
>>I created a new table of the same structure using the following:
>>
>>
>>select DBF_EXIST
>>afields( aDbfStruct )
>>create table DBF_NEW free from array aDbfStruct
>>
>>
>>Then I scan the corrupted table and copy all fields to the new table. Then drop the existing table, and rename the new one.
>>But at the end the corruption is not fixed.
>>
>>I thought that by creating a new table, VFP would create a new header and the problem would be fixed. Yet, it does not work that way.
>>
>>What am I missing?
>>
>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham