missing or broken / 'dao2535.tlb

[klafert]

Over a year a go I got the error "your Microsoft Access database or project
contains a missing or broken reference to 'dao2535.tlb" version 3.5. The
database was original written in Access 97. I was able to use Office 2003 to
convert the data base. This has worked well. However, today I set up a new
computer and loaded Office XP - Including the Access XP. I have 4 computers
with the same version of Access and the computer giving me the problem. The
other 4 continue to have no problem with the Access database. However, the
new installation does. I checked the path and it is the same. Is there an
option in Access I need to set? It can't be the database because it works
fine for the other 4 computers and has for over a year?

 

[Allen Browne]

The dao2535 library was the compatibility layer that allowed Access 97 to
use databases with code from the Access 2 days. That library has never
worked correctly with Access 2000 or later.

Open a code window, choose References on the Tools menu, and try unchecking
the library. Then try compiling your database (Compile on Debug menu.) If
the library is not needed, your project will compile and that's all you need
to do. If there is old code, attempting to compile will highlight the parts
that need changing, and you can bring your database up to date. In many
cases, that's not a major task - possibly less than an hour's work if you
know what you are doing and the database does not contain complex stuff or
16-bit API calls.