2000 to XP

[rschultz]

We just upgraded from Office 2000 to XP and when a user goes into a database he created he gets a message that says, "Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5"

What is that and how do we fix it?

 

[Mile-O]

It means you are missing a reference to the library you stated which is Microsoft Data Access Objects (DAO) 3.5

Access XP is defaulted to the new "standard" ActiveX Data Objects (ADO) and that's why you are having this error.

To sort it:

Open a module
Select Tools -> References from the menu
Look for Microsoft Data Access Objects 3.5 in the huge list
Ignore it - we'll take Microsoft Data Access Objects 3.6 (it's better)
Check its box
Move it up through the priorities until it is above Microsoft ActiveX Data Objects
All set and ready to go.

 

[Newman]

Move it up through the priorities until it is above Microsoft ActiveX Data Objects

I didn't know that there was a rank in references.
Can you tell me more about it?

 

[rschultz]

thanks, we'll give that a try.

 

[Newman]

Thanks Pat!
It is so clear hearing it from you.
Wish it was as clear with the MS Help files.
Well, while waiting for your book, got to do with there help files.