>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