Error Message

[Erika]

Any ideas what the following message means:

MS Office Access Database or project contains a missing or broken reference
to the file 'dao2535.tlb' version 3.5

 

[SusanV]

Open the visual basic editor, under the Tools menu, select References. You
should see an entry marked MISSING - select that reference (check the box).
If none are marked missing, scroll down through the list until you find
Microsoft DAO 3.5 Object Library and select that.

Recompile and you should be all set.

 

[Erika]

I did as suggested, I went to visual basic and references. There were more
selected that just the one discussed in the original message. Then I
compiled via "Debug > Compile".

Now I am getting an error that reads:

Compile Error: Can't find project or library

 

[SusanV]

Did you unselect anything? You shouldn't have...

I did as suggested, I went to visual basic and references. There were
more
selected that just the one discussed in the original message. Then I
compiled via "Debug > Compile".

Now I am getting an error that reads:

Compile Error: Can't find project or library

 

[Erika]

No, I left all the items selected. When I opened up the window, they were
selected by default, so I ran with it that way.

 

[SusanV]

Was something marked missing?

No, I left all the items selected. When I opened up the window, they were
selected by default, so I ran with it that way.

 

[Erika]

Yes I had one marked Missing, it said

Missing: DOA 2.5/3.5 Comp

I selected it, clicked ok

 

[SusanV]

What line of code was highlighted when you got the error?

 

[Erika]

MsgBox Error$

What line of code was highlighted when you got the error?

 

[SusanV]

What does that line of code do? Did you try remarking it out then
recompiling?

 

[Douglas J. Steele]

Error$ is the deprecated way of referring to Err.Description.

The Err object comes from the VBA library. However, since VBA is the last
library Access checks from the list of References, it's rare that there's a
problem with the VBA reference. Correct any problems with the References
collection, and that error should go away.

 

[SusanV]

Thanks for the info Doug - I hadn't come across that error before!

;-)
SusanV