Reference library loading

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ctdak - 19 Sep 2006 07:53 GMT

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.

Reply to this Message

Alex Dybenko - 19 Sep 2006 09:13 GMT

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.

Signature

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

>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
[quoted text clipped - 6 lines]
> file
> with the correct path for the desired library.

Reply to this Message

ctdak - 20 Sep 2006 04:51 GMT

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

> Hi,
> there is no need to correct references in application. once you set all
[quoted text clipped - 15 lines]
> > file
> > with the correct path for the desired library.

Reply to this Message

Alex Dybenko - 20 Sep 2006 08:39 GMT

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

Signature

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

> OK, but my question is: "Can you use Application.References to install the
> needed reference libraries?" I would like to avoid manually installing
[quoted text clipped - 25 lines]
>> > file
>> > with the correct path for the desired library.

Reply to this Message