Solved

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

Posted on 2006-06-27
5
282 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views 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 Microsoft Access…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

860 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