Solved

Broken Reference to the file dao2535.tlb error message on opening Access Data Base created in Access 97

Posted on 2007-11-28
14
8,479 Views
Last Modified: 2012-06-27
I have been using an Access Database originally created with Access 97 on a laptop which has upgraded to Access 2002.  I am now attempting to open the same Access Database on a computer which is running Windows 2003 and Microsoft Access 2003 and I am getting the following error message: "Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5."

The database contains historical data going back to 1991 and various reports which would require a significant effort to recreate and at the very least I need to export the tables to recreate the database.  My laptop has gone down and I am in a critical time cruch to produce reports from the database and need to resolve my problem ASAP.  Your prompt response would be greatly appreciated.

Grant Keener
0
Comment
Question by:gkeener3
  • 4
  • 3
  • 2
  • +3
14 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 20366699
>I am now attempting to open the same Access Database on a computer which is running Windows 2003 and Microsoft Access 2003
This computer does not have 'Microsoft DAO 2.5/3.5 Compatibility Library' installed on it, which your app apprently references, therefore requires in order for it to run.

Go find it off your laptop, then paste it into this new pc.  Then re-open the Access app.
On my pc this is at c:\Program Files\Common Files\Microsoft Shared\DAO\DAO2535.tlb
0
 
LVL 75
ID: 20366720
Ditto for that location on my PC's.

mx
0
 
LVL 20

Expert Comment

by:clarkscott
ID: 20366930
or select a later version from the Reference List.  You probably have one and it will probably work.

Scott C
0
 

Author Comment

by:gkeener3
ID: 20366970
I don't have access to my laptop to copy the file and the VB editor does not give me access to the Tool:Reference tool bar and I have no experience editing the VB coding.  Is the dao2535.tlb a unique file created by the Access Database or is it a generate file which I can down load and install on my new computer?
0
 
LVL 75
ID: 20366979
It's an Office file that is standard in any Office installation.

mx
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 125 total points
ID: 20367009
>Is the dao2535.tlb a unique file created by the Access Database
No, it is a Microsoft-created object library that was the primary means of data access in all Access versions up to 2000-ish.

Last I remember there were some versions of Windows, XP and higher, (Office XP and higher?) that did not automatically have DAO installed.
This was along the thinking that M$ was going to discontinue DAO, but has yet to actually do so.

Copy the file from any machine you can find it on and paste it into the new machine.  Until proven otherwise, that should resolve your issue without any coding.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:gkeener3
ID: 20367011
Is this a file that I can down load and install on my new computer?
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 125 total points
ID: 20367013
0
 
LVL 20

Assisted Solution

by:clarkscott
clarkscott earned 125 total points
ID: 20367097
There's a few newer versions.
From the database window, click MODULES.
If there are any on the list, click and open in design mode, otherwise create a new one.
At the top of the code screen, click on Access' TOOLS and select REFERENCES.
You will see one (dao) that is MISSING (it will say this in the description).
Uncheck the box to the right.
Scroll down the list and locate another DAO version (3.51, etc.) and click the box on the right.
Close Access

PS.  You don't have to save the module if you created a new one.

That's all there is to it.

Scott C
0
 

Author Comment

by:gkeener3
ID: 20367107
I downloaded the file dao2535.tlb and copied it into my directory  C:\Program Files\Common Files\Microsoft Shared\DAO.  When I open the Database I am still getting the same error message. Am I doing something wrong or do I need to do something else?
0
 
LVL 75
ID: 20367309
Open the vba editor.
Tools>>References.
If you see 'Missing' for this file, uncheck it.
Then, Browse to the Program Files location and select the file you downloaded.
Close the window .
Then ... Debug>>Compile.
If this works, you should be ok.

mx
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 125 total points
ID: 20367549
You could also most likely upsize this to 2000 or greater with no issues. Of course, if you do this you wouldn't be able to work with that copy in Access 97 any longer ...
0
 
LVL 1

Expert Comment

by:Computer101
ID: 21208283
Forced accept.

Computer101
EE Admin
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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 …

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now