Prev: how to create a multi-part IF statement
Next: Many to Many Relationships
From: klafert on 6 Jan 2006 06:53
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?
From: Allen Browne on 6 Jan 2006 08:00
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"klafert" <klafert(a)discussions.microsoft.com> wrote in message
news:CF0C49FB-605A-4A76-89F2-3D11D3823451(a)microsoft.com...
> 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?


 | 
Pages: 1
Prev: how to create a multi-part IF statement
Next: Many to Many Relationships