Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fix corrupted table
Message
De
24/05/2009 02:52:15
 
 
À
23/05/2009 08:44:48
Mark Phillips
Erw Custom Programming Inc.
Waterford, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01401632
Message ID:
01401683
Vues:
66
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform