Solved

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

Posted on 2006-06-27
5
280 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
ID: 16993968
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
ID: 16993980
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
ID: 16993987
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
ID: 16994049
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
ID: 16994061
At least u can, Im still stuck in the office!

0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

932 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

20 Experts available now in Live!

Get 1:1 Help Now