Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 2091
Message
From
13/02/2008 15:46:16
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
01292365
Message ID:
01292377
Views:
23
>One of my databases recently got this corrupted table error. I've been browsing through some past threads on this subject and have seen mostly references to tools such as FoxFix. Are there any ways that anyone knows of to fix this without purchasing software? I tried one method listed on here of a command window fix, but it did not resolve the problem. Thanks for any recommendations or advice.

One general approach:
- copy the contents of the table out to another temporary table (either a free table or a temp table in your DBC, or maybe even a cursor [make sure you use NOFILTER if you use a cursor])
- overwrite the bad table with a known good copy (.DBF, .CDX and .FPT as appropriate), either from backup, or created anew (the GenDBC utility can help here). It doesn't matter if the backup or new table has incomplete records, or none at all
- if the restored file from backup has any rows, ZAP the table
- append from the temporary table/cursor to your known good table

Make sure you back up everything first. If your table is in a database and has lots of long field names, indices, triggers etc. you may need to be careful.

Depending on the type of corruption you may not get all your rows back, or there may be subtle errors that may be hard to detect but at least this should get you past the error you're seeing.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform