Possible to add reference to library through VBA

[Guest]

Is it possible to add a reference to a library through VBA if the reference
isn't already added. Or am I wrong here and will the library's automaticly
added to my application on no wether what computer I will run it?

 

[Douglas J. Steele]

References are contained in the MDB file. If the same version of the
referenced library exists on the computer, there's no problem. If the same
version of the referenced library doesn't exist on the computer, there will
be problems (and you won't be able to set a reference anyhow if the library
doesn't exist...). It's not as though you add references to msaccess.exe.

There are 2 methods of the References collection that allow you to add
references (AddFromFile, and AddFromGUID), but I'm not really sure whether
you need them.

What exactly is the situation about which you're worried?

 

[Guest]

Suppose a library doesn't exist on the computer, what do I do then. Because
my application won't run without it.

 

[Douglas J. Steele]

You have to copy the missing file(s) to the computer (if you can legally),
and make sure they're properly registered.