acotgreave
asked on
Corruption recovery: "Microsoft Office Access can't find the macro 'TrackDBaseForms'"
Hi,
I've corrupted a database. In an effort to recover it, I have created a new database, and imported all tables, queries, forms, reports, macros from the corrupted database into the new one.
However, when I try to open most of the forms, I get the error message:
"Microsoft Office Access can't find the macro 'TrackDBaseForms'
The macro (or its macro gruop) doesn't exist, or the macro is new but hasn't been saved...."
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.
Does anyone know of other ways I can look for this missing definition?
(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 - is there a way to open a database without that form opening?)
Thanks
Andy
I've corrupted a database. In an effort to recover it, I have created a new database, and imported all tables, queries, forms, reports, macros from the corrupted database into the new one.
However, when I try to open most of the forms, I get the error message:
"Microsoft Office Access can't find the macro 'TrackDBaseForms'
The macro (or its macro gruop) doesn't exist, or the macro is new but hasn't been saved...."
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.
Does anyone know of other ways I can look for this missing definition?
(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 - is there a way to open a database without that form opening?)
Thanks
Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have u tried decompiling the original DB?
Back it up first before u do
http://www.granite.ab.ca/access/decompile.htm
Back it up first before u do
http://www.granite.ab.ca/access/decompile.htm
ASKER
Phew! I never knew the Shift key command. That's just what I wanted to know- how to open the database without my pesky code running.
Thanks to that, I can now leave the office and go watch some World Cup football without being in a panic!
Cheers
Thanks to that, I can now leave the office and go watch some World Cup football without being in a panic!
Cheers
At least u can, Im still stuck in the office!
What u should do is copy the code behind the form, then select No on Has Module
then import that form
then paste the code back in and register all events