Corrupt Access 2003 File

[Ayo]

I was working on this file earlier today, I even just opened it and it was
fine and all of a sudden there is a write delay to the save the file, I
closed it and I try opening it again and it is corrupted. I don't get it. The
message I am getting is below. What does that mean. I just finished making a
lost of update to the file. The last time I backed it up was Tuesday, and I
have done a lot of work to it between then and now. I don't have the time to
go back and redo all that work again. Any help will be appreciated.

"Microsoft Office Access has detected corruption in this file. To try to
repair the corruption,first make a backup copy of the file. Then, on the
Tools menu, point to Database Utilities and click Compact and Repair
Database. If you are currently trying to repair this corruption then you will
need to recreate this file or restore it from a previous backup."

 

[Ken Snell \(MVP\)]

The message means that the database file likely is corrupted -- meaning most
likely that at least one record in one table (and possibly more) is
corrupted and ACCESS cannot read the data. It also may mean that a form or
report or other object has become corrupted.

Number one rule -- ALWAYS make very frequent backups of your file when
you're doing development work. My rule of thumb is to make a backup after
the addition of each new feature or new code.

Do exactly what the error message says for you to do. If the compact and
repair does not work, sometimes you can decompile the database (using the
/decompile switch when opening the file through a call to msaccess.exe file)
and that will work. Use Start | Run to run this program (replace generic
path/file names with actual names):
"msaccess.exe" /decompile "PathTomdbFile\Filename.mdb"

If not, try creating a brand-new file and importing all objects from the
corrupted file.

See Tony Toews' article for information about corrupted databases for more
information:
http://www.granite.ab.ca/access/corruptmdbs.htm

If none of these methods work, you'll need to go back to your Tuesday backup
and redo all the work.