Reference Library Error

[Guest]

I have an Access 97 database that needed updating. I used Access 97 to make
the changes (some form, report, module). They were all fairly simple
changes. Once I put the database out to be tested by the user, a compile
error stating "Can't find Project or Library" is generated. The code is
maniputing excel worksheets and utilizing Outlook to obtain the user's name.

I do have newer versions of other office programs on my computer. The
production copy references Excel 8.0 and Outlook 9.0 Object Libraries. My
test copy references Excel 11 and Outlook 11 Object Libraries.

How can I make the test copy reference the old libraries? And can I do this
from my computer?

Thanks

 

[Douglas J. Steele]

You can't reference a library unless it exists on the machine, therefore the
answer is you can't.

What you can (and should) do is use Late Binding, where you don't need to
set a reference at all. Tony Toews has an introduction to this topic at
http://www.granite.ab.ca/access/latebinding.htm