Missing reference in VBA?

G

Guest

I occasionally get a missing reference error on a PC when installing an
Access (2002) application onto a new PC. Normally, the reference name is
similar to the MISSING one, and I can slog through the reference table and
find it. This time however, I got a MISSING "FlUPL.OCX" reference. I have NO
IDEA where to find that. Is there a tool or function that can tell me what
library a missing ref is in?

Additionally, is there a way to get Access to automatically attempt a
re-reference for a missing one? We have a need to do that with the MS Office
Web Functions Library

Thanks for any insight!
 
D

Douglas J. Steele

The only surefire way is to check on the machine where the database was
created.

No, there's no way to get Access to automatically attempt a rereference. One
approach is to use late binding, rather than setting the reference in the
first place. Tony Toews has an introduction to this topic at
http://www.granite.ab.ca/access/latebinding.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top