Compile error: Can't find project or library

[Laurel]

I have an application running on 4 different computers at a school. On one
of those computers, I get the error "Compile error: Can't find project or
library." And the word "left" is highlighted in this line of code:

ls_select = Left(qdfBaseQuery.SQL, li_order - 1)

This computer is also missing the Linked Table Manager (see "Installation
question - linked table manager", now solved.

Can anyone tell me what I need to do to solve this? If it's re-installing,
please be very specific about what I need to do during the installation, as
I don't have back-and-forth access to this newsgroup when I'm at the school.

tia
las

 

[Guest]

Laurel,

I think you should activate the DAO Library.
1. Open VBA by pressing ALT-F11
2. Goto - Tools - References
3. Check the option "Microsoft DAO xx" (where xx stands for the available
options you have...
4. While you're at it compile the project - Compile in menubar.

Maurice

 

[Laurel]

Since I have to go to the school before trying this, let me ask this. Is
this activation something that is stored on the computer, or in the mdb?
Because each computer has exactly the same application mdb. If it's stored
in the mdb, then maybe something is missing from the environment? Or maybe
the xx was different on this computer.... That would make sense.

 

[Douglas J. Steele]

The problem is that Access stores the details of all linked libraries
internally, including the location of the file and its specific version.

If the expected libraries aren't in the exact same location, and the exact
same version, Access can run into problems. This happens often if you try
using the application on a machine other than the one where it was
developed, or even if you install software on that updates the referenced
libraries on the development machine.

For far more than you could ever want to know about this problem, check out
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html, or check my
December, 2003 "Access Answers" column in Pinnacle Publication's "Smart
Access" (you can download the column, and sample database, for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html)

 

[Laurel]

Indeed, once I was able to change the location of the database in the linked
table manager (see "Installation question - linked table manager"), this
problem went away. Thanks for saving me some extra effort!