[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

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
0
acotgreave
Asked:
acotgreave
  • 4
1 Solution
 
rockiroadsCommented:
Have u tried looking at hidden objects?
go to Tools/Options and show hidden objects


to open the database without startup, u can depress the SHIFT key then open the DB. Note u may need to do this a few times

0
 
rockiroadsCommented:
Note when u copy forms, u run the risk of corrupting new DB

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
0
 
rockiroadsCommented:
Have u tried decompiling the original DB?
Back it up first before u do

http://www.granite.ab.ca/access/decompile.htm
0
 
acotgreaveAuthor Commented:
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
0
 
rockiroadsCommented:
At least u can, Im still stuck in the office!

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now