- make backup copy of your database.
- Start a blank database,
- Import all there is from bad.mdb to this blank database.
Note: The process may stop while importing certain form or report.
Take note of this object. Try it again but this time avoid importing that particual object.
- Import the bad object from a recent copy,
(at this point, it may allow you to import the bad object you were avoiding.
try importing it. If you were able to import it, it will be called say frmCustomer1
because frmCustomer existed befor hand. Rename frmCustomer as frmCustomer2
and also rename frmCustomer1 bad one as frmCustomer).
- Regardless the outcome of last step, try to compact and repair it.
- Delete frmCustomer3 later after taking care of the problem.
Just in case look this post. http://www.sqlservercentral.com/Forums/Topic1621376-384-1.aspx
If your tried decompile and it still won’t work, u are pretty much screwed hate to say it. hope you have a recent backup. I don't know, but maybe you somehow will be able to help this program to save your data. http://www.oemailrecovery.com/access_repair.html
Occasionally access db's get hopelessly corrupted for no apparent reason. This is why I back up may db about 5 times a day when I am coding.