Getting into my Access database

[dbs_help]

I am having a problem entering my Access database. After clicking on my Desktop shortcut, I see the following error message:

Your Microsoft Office Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5. When I click on the "Show Help >>" button below, I get the following explanation.

The application you are attempting to use has a reference that it cannot resolve to an object, type library, DLL, or
external database. Either the object, type library, DLL, or database was deleted or renamed. Examine the Available references list in the References dialog box in the Visual Basic Editor ( Tools menu) to determine if any action is required. If you did not create this application, contact the programmer or administrator of the system.
If the reference listed in the Available references list is preceded with "MISSING:" clear the check box to remove the reference if it is no longer required. If you still need to use the reference, clear the check box entry for "MISSING: <referencename>" in the Available references list, and then create a new reference to the file using the Browse... button. If this is an installed database application, you may need to reinstall or repair the application.

I am puzzled by all this and would be grateful for any assistance.

By the way, by repeatedly clicking on the "OK" button, I am able to finally get into my database.

 

[Zigzag]

Once you are into you database Pree CTRL + G
When the Visual Basic Form opens Click on Tools > References
It will now display a list of references , one of them will say missing.
Post back with the information of the missing one.

 

[dbs_help]

Microsoft Visual Basic for Applications Extensibility 5.3

 

[dbs_help]

I forgot to mention that in the list of checked Available References, I have the following:
MISSING: Microsoft DAO 2.5/3.5 Compatibility Library
MISSING: utility.mda

 

[Zigzag]

What version of MS Access do you have installed on your machine and what what version of MS Access was your DB created with?

 

[dbs_help]

Access was installed on the network with version 2003 while I am using Access 2007 on my computer.

 

[dbs_help]

I cleared the check boxes on the MISSING: lines and now have complete access to the database

Thanks for your help

 

[Zigzag]

You might find that certain code will not run without these references but you will only find that out when it happens.
Well done.