Solved

Access error message: missing or broke reference to the file 'dao2535.TLB' Version 3.5

Posted on 2007-04-02
4
892 Views
Last Modified: 2008-01-09
Some of our users have been working with Office 200 and were recently upgraded to Office 2003 via a Tivoli push.

One person tried to open an Access database that is regularly used and received this message: Your Microsoft Office Access Database or project contains a missing or broke reference to the file 'dao2535.TLB' Version 3.5.  To ensure that your database or project works properly, you must fix this reference."  He clicked OK and it seemed to open fine.  

He hasn't received any more messages like this but wants to be sure there isn't a problem with his database.  Could it be related to the upgrade or is there something else we should be checking?
0
Comment
Question by:Olga_Bianchi
  • 2
4 Comments
 
LVL 27

Expert Comment

by:Jonvee
ID: 18835748
If he has not received any more of these messages, there may well be no problem.
However, there's a suggested resolution here, should it recurr  >>

"Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5."
http://www.opentechsupport.net/forums/showthread.php?t=7659
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 18835753
>were recently upgraded to Office 2003
Many versions of Office > 2000 and Windows >= 2000 do not come with the Microsoft Data Access Objects (DAO) object model, so you'll have to find that file and added it after the install.

Either that, or the install replaced the version of DAO these apps used with a higher version, which meant that when your apps open and can't find the version they're used to, it displays the reference error you are experiencing.

Either change your Access apps to use the higher version of DAO that was in the install, or deploy the 'dao2535.TLB' file to all users that had the upgrade.

Lucky you.

Hope this helps.
-Jim
0
 
LVL 27

Expert Comment

by:Jonvee
ID: 18836450
@ Jim Dettman:    Ok, thank you.   Understood.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to execute an access 2007 module from vb6 2 32
extend monitor issues 6 28
Modal form 11 29
Dlookup MSACCESS 5 24
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

816 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

11 Experts available now in Live!

Get 1:1 Help Now