Fixing Error: 2091 Table "name" has become corrupted. The table will need to be repaired before using again.

Have you ever encountered Error: 2091 Table "name" has become corrupted. The table will need to be repaired before using again in Visual Foxpro 8.0? It usually appear after a certain table was accidentally corrupted due to power failure or improper shutdown of Windows (because of delay write mechanism of windows). I only encountered this kind of problem in version 8.0 but in version 7.0, there were no incident of this error.Now, if in case you ask the HELP file of Visual Foxpro on how to repair this kind of problem, you'll be recommended to ask for Third-Party programs to repair this error. Woohh, another fee!

Now of course. you will not tell your client to pay another fee just to repair the database or re-encode their data, you might get in trouble hehehe…For cure, try using previous version of Visual Foxpro 8.0 like version 7.0, now its your problem to look for it. Open your table using the previous version and copy it to a different name (using: COPY TO newname), reconstruct its indices and re-open it in version 8.0, rename.

But of course prevention is always better than cure! Try to put a code in your program that automatically creates a duplicate copy of your tables, index files and databases and automatically copy to good file from your duplicates if in case the error triggers (use ON ERROR). Set-up a back-up routine. Inform the user to properly shutdown the computer and regularly perform back-up. Use UPS for power back-up. Better is to use MySQL as your database instead of the native database/tables of VFP but this will be a different story.