Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt table
Message
From
08/10/2002 18:09:26
 
 
To
08/10/2002 17:26:05
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00709049
Message ID:
00709063
Views:
17
>I have a free table that was originally created in Clipper. When I try to browse this table in VFP 8.0, I'm told the file is corrupt. However, I can still open it with VFP 7.0.
>
>Any ideas?

We made a change in VFP8 to address the issue described in http://support.microsoft.com/support/kb/articles/q293/6/38.asp. Records added in a transaction can be lost when the table is corrupt in such a way that the header record count disagrees with the actual number of records in the table.

Now we check at USE whether the header record count and actual number of records in the table agree, and give the error if the table is corrupted, i.e. the two don't match.

I suspect this is what you are seeing. You should be able to clear the problem by PACKing the table in VFP7. Let us know if the PACK does not clear the error, as we may be looking at something else.

Thread 580276 contains some additional info about this corruption issue.

If the problem happens at BROWSE rather than USE, then I would suspect an index problem rather than table corruption.

If this is the case, you could do a Ctrl+C on the error dialog (this works in VFP7 and later) to copy the exact error text, and post it back here.
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform