Solved

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

Posted on 2007-04-02
4
902 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 66

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

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…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

688 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