Nadya,

having read you problem I assume that you can open the file but have problems accessing its data. Can you export the data, drop the table, create it again and reimport it. I asume that the problem is data related. Can you email me the database. I have been able to fix some problems using FPW26.

Regards,

Ron

>I still can not open the database file. How else can I attempt to fix the database file (DBC)?
>
>>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.