How to register ActiveX control with VBA?

[Guest]

Hi,
I've developed an application with some activex control. Not all users have
this control installed / registered on their system. How can I check with
some VBA code if the control is available (see the list in the window Tools >
ActiveX Controls), and, when not, to register it? (i.o.w the proces that
happens when the button Register is pressed)

Thanks in advance,
Regards,
Henk

 

[Alex Dybenko]

Hi,
it is not a good idea to do this from VBA, if you don't have controls
installed, and your project has references to these controls - then VBA most
likely fail
You have to register these controls during setup, or ask users to register
using regsvr32.exe

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

 

[Guest]

Thanks, Alex.
The situation is as follows: the users have Access installed on their
desktop. I've developed a (secured) .mdb accompanied by a security .mdw file,
which are placed on a network drive. For users to use the system they need a
shortcut .lnk and when needed registering the control. I have no more
experience with installing than saying "place it on some network drive and
edit the sample .lnk file for the location of the .mdb and the location of
the local Access exe". (for my C++ applications I use InstallShield). Now
I've just downloaded an Access application wherewith one can automate the
creation of the shortcut .lnk. In this application, which does not contain
the control, I would also handle the registration of the control, but I don't
know the needed VBA.

Regards
Henk Stijnen

 

[Alex Dybenko]

Hi,
if access is already installed - then you can also use InstallShield to
install mdb file, create a shortcut and install/register all ActiveX
controls you using. This would be the best idea

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