Access Database problems

Posted on 2013-09-06
Medium Priority
Last Modified: 2013-09-19
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
Question by:asp_net2
  • 3
  • 2

Expert Comment

ID: 39470176
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
LVL 59
ID: 39470466
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.

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.


Author Comment

ID: 39470722

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.

Accepted Solution

scraby earned 1500 total points
ID: 39483712
open the database while holding the left shift key on the keyboard, this will open the database in design mode.  onced opened, press alt - F11 to go to the vba editor. to get to the references in the editor under tools menu, select references.

to find broken references here's an exerp from an ms article (link below)

The BrokenReference property
The Application object for Access has a BrokenReference property that tells you if any references are broken. To check the BrokenReference property, follow these steps:
1.Start Access.
2.Open an Access database.
3.Press ALT+F11 to open the Visual Basic Editor.
4.Press CTRL+G to open the Immediate window.
5.In the Immediate window, type the following command, and then press ENTER:
Notice that the BrokenReference property for the Application object returns True if there are missing references. Otherwise, the BrokenReference property returns False.

LVL 59
ID: 39486400
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.


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This is an article on how to answer questions, earn points and become an expert.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

621 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