Solved

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

Posted on 2007-04-02
4
896 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

680 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