Reference library loading

[Guest]

I notice that Application.References. … is available in VBA. What are the
uses of this? Can this be used upon application startup to make sure certain
reference libraries are loaded for a particular application, such as "MS DAO
3.6 Object Library" for instance? If so, how do you test first for different
versions of Access that users may be running and then load the correct file
with the correct path for the desired library.

 

[Alex Dybenko]

Hi,
there is no need to correct references in application. once you set all
references during development - then you have to be sure that you have all
libraries listed there are installed and registered on target PC. then all
references will be in place.

normally you can use Application.References to find out which references are
missing.

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

OK, but my question is: "Can you use Application.References to install the
needed reference libraries?" I would like to avoid manually installing
libraries on each target PCs.
ctdak

 

[Alex Dybenko]

Hi,
no, you can not install libraries using references. in order to install
libraries, which are not part of access and office installation, you can
build a setup and ask people to run it on their PC.
there are also free installers you can use:
http://alexdyb.blogspot.com/2005/03/freeware-installers.html
http://alexdyb.blogspot.com/2006/04/one-more-free-installer.html
http://alexdyb.blogspot.com/2006/06/one-more-free-installation-system.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com