Solved

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

Posted on 2006-06-27
5
284 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

730 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