Solved

Corruption recovery: "Microsoft Office Access can't find the macro 'TrackDBaseForms'"

Posted on 2006-06-27
5
278 Views
Last Modified: 2010-05-18
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
Comment
Question by:acotgreave
  • 4
5 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
Comment Utility
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
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
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
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
Have u tried decompiling the original DB?
Back it up first before u do

http://www.granite.ab.ca/access/decompile.htm
0
 

Author Comment

by:acotgreave
Comment Utility
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
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
At least u can, Im still stuck in the office!

0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now