Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fixing corrupted table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP3
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972234
Message ID:
00972868
Views:
13
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform