Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fix corrupted table
Message
From
24/05/2009 02:52:15
 
 
To
23/05/2009 08:44:48
Mark Phillips
Erw Custom Programming Inc.
Waterford, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01401632
Message ID:
01401683
Views:
65
>Can anyone help me fix this error?
>
>Table "name" has become corrupted. The table will need to be repaired before using again. (Error 2091)
>
>Either the table record count does not match the actual records in the table, or the file size on the disk does not match the expected file size from the table header. Repair the table using an appropriate third-party repair utility for Visual FoxPro tables before opening the table again.
>
>Thank you for your help...

We've had some success with the following trick. I don't know why it works, but, in many cases, it does. (No gurantees, of course)
SET TABLEVALIDATE  TO 0
USE myTable
GO BOTTOM
BROWSE
    append four or five blank records
    go to the first new record
DELETE REST
USE
Previous
Reply
Map
View

Click here to load this message in the networking platform