Try to Repair a corrupted Database (MDB File)
How a MDB get corrupted? WHAT IS GOING ON?
My first thought is, WHERE IS THE “DAM” BACKUP? A project without backups it’s NEVER a good project (In - Joao Tito Livio head, brain cell 165.554), simply there are many ways this happen. This are my suggestions in order to fix this a corrupted MDB file.
Try to repair your MDB in command line mode how? http://support.microsoft.com/default.aspx?scid=kb;en-us;209207
Example: C:\PATH_TO\Msaccess.exe c:\PATH_TO\Database.MDB /Repair
Don’t forget to replace PATH_TO with your PATHS
At this time u may think “This really sucks” but do you have all windows and office updates installed? If not this is my Second suggestion, update windows and office http://windowsupdate.microsoft.com/ & http://office.microsoft.com/en-us/officeupdate/default.aspx. Why? Nothing is perfect I AM NOT
Consider to create a new MDB File and import all Objects with no exceptions. If some object give error DO NOT IMPORT IT, just skip and try to make a new one and copy paste Objects and Code.
Use the JETCOMP utility to fix Microsoft JET; this may be the goal http://support.microsoft.com/kb/q295334 .
Update your MDAC and JET to latest version. http://msdn.microsoft.com/data/downloads/default.aspx
If nothing above produces result, try to get a 3rd Party Utility to fix it.
REMEMBER
A project without backups it’s NEVER a good project. A MBD corrupted may cause lost of Data, hours of work and of course, Money. Make backups of your MDB periodically but DO NOT OVERIGTH in the same version. Keep at least 10 last releases before overnight your project.