Try dropping your indices first. In some occasion this causes the problems.
You can delete your index file and open the dbf in VFP. VFP will notice this and still open the file (without the index).
Try this on a copy (of course).
Regards,
Ron
>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.