Avatar of Brian
BrianFlag for United States of America asked on

Access Database problems

Hello Experts,

I have been asked to move an Access 2000 database to be put on a new desktop computer that runs Office 2013. I believe I got all the files/folders that the Access database consists.

When I try to run the application from Access 2013 I get the following error message below.

Just an FYI, I did not create this database. I was asked be my client to move it to a newer updated system and this new system runs Office 2013.

Message that I receive when trying to run the application:

first error
second error
third error
Microsoft AccessMicrosoft Office

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)

8/22/2022 - Mon
scraby

sounds like the event handler is not able to interpret these events.  are you able to get into the vb code after these errors?  open the database while pressing left shift.

not sure on compatability between 2000 and 2013 but you may try uninstalling 2013, installing 2000, open the db to make sure all is well and then install 2013 on top of 2000 and see what it does
scraby

Jim Dettman (EE MVE)

You have broken references.  You need to open the VBA editor window and goto tool/references and see which are missing or broken.

 Once corrected, compile the app and make sure there are no errors.

 The app will run after that.

Jim.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
Brian

@JDettman,

Ok, I'm new to Access. Can you tell me what references are? How would I know what references are missing/broken. Also, what do I need to do to correct the missing/broken references?

Also, how do I compile.
ASKER CERTIFIED SOLUTION
scraby

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jim Dettman (EE MVE)

There have been cases as well where references are not listed as "MISSING" or "BROKEN".

If you don't see any like that, check any unchecked reference (doesn't matter which), close the DB and Acces, re-open and uncheck the reference you just checked (it will be the last).  Then do a compile.

That forces a refresh of the references collection in VBA.  If there are any problems, they will come to the surface.

Jim.