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
LVL 4
asp_net2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

scrabyCommented:
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
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

asp_net2Author Commented:
@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.
0
scrabyCommented:
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:
?Application.BrokenReference
Notice that the BrokenReference property for the Application object returns True if there are missing references. Otherwise, the BrokenReference property returns False.

http://support.microsoft.com/kb/824255
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.