Access can't find the macro

[lestermathews]

Hello everybody!

I have one corrupted database. I decided to try to restore it. VD I created a new database and imported all tables, queries, forms, reports, macros from corrupted database to the new one.

However, when I try to open most forms, I get the error message:

"Microsoft Office Access can't find the macro 'TrackDBaseForms'

The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved...."

This base worked for a year, and I never had this problem. A Google search returns zero results. However, it's not obviously in the macros page, or in any code I can find.

I've been supporting this database for a year, and have never come across this missing macro. A Google search returns zero results, so I assume it's something that the early developers did. However, it's not obviously in the macros page, or in any code I can find.

The corrupted database is in such a state that it won't open at all: the main form that is set to open on startup corrupts. MS Access 2007, size 500mg.

Thanks!

[lestermathews]

 Any help would be appreciated! 

[GilbertMcdougal · Accepted solution]

Have u tried looking at hidden objects?
Go to Tools/Options  and show hidden objects to open the database without startup.  You can depress the SHIFT key then open the DB. Note you may need to do this a few times.

I hope this recommendation will help you. In extreme cases you can restore the data file via ms access repair tool as Access Recovery Toolbox . http://www.oemailrecovery.com/access_repair.html  

[lestermathews]

Thank you for the great solution!