Do Libraries become a part of an MDE

[Programmer - wannaB]

If I biuld a database with a variety of active-x controls from different
libraries and I build the front end into an MDE will the library files stay
with it or do they still need to be loaded on each PC that this runs on?

 

[Tony Toews [MVP]]

If I biuld a database with a variety of active-x controls from different
libraries and I build the front end into an MDE will the library files stay
with it or do they still need to be loaded on each PC that this runs on?

We avoid ActiveX controls if at all possible given all the troubles
you can have with different versions and distribution troubles.

How do you get rid of troublesome ActiveX Controls/references?
http://www.granite.ab.ca/access/referencetroubles.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tom van Stiphout]

On Fri, 14 Dec 2007 13:28:03 -0800, Programmer - wannaB

No. You'll need a setup program (or a lot of patience) to install
them on each PC. This can cause problems if different versions of such
controls are already on the machine. In a nutshell: if you install a
newer version you may break another application, while if you install
an older version the newer one may break your application.
This is one of the problems of components that .Net is trying to
solve.

Better to consider these issues before you set out to build your app.

-Tom.

 

[Tony Toews [MVP]]

This is one of the problems of components that .Net is trying to
solve.

And various mutterings I've read indicate limited success.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

On Fri, 14 Dec 2007 13:28:03 -0800, Programmer - wannaB

No. You'll need a setup program (or a lot of patience) to install
them on each PC. This can cause problems if different versions of
such controls are already on the machine. In a nutshell: if you
install a newer version you may break another application, while
if you install an older version the newer one may break your
application. This is one of the problems of components that .Net
is trying to solve.

Better to consider these issues before you set out to build your
app.

I avoid external ActiveX controls except where they are required.
Some kinds of ActiveX controls can be replaced by VBA code
(encryption is one such example). If you can find VB code that
builds a DLL or ActiveX control, you can easily port it to VBA.