Re: How to register ActiveX control with VBA?

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

"hstijnen" <hstijnen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9A52279A-3189-4C2B-974D-CA7AC3479905@xxxxxxxxxxxxxxxx
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" wrote:

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

"hstijnen" <hstijnen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B202FFF7-3E19-45B6-8677-161D72E2E630@xxxxxxxxxxxxxxxx
> 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



.