Storing an OCX in a table then registering it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ricardo - 05 Aug 2005 07:28 GMT

I am using the Microsoft Common dialog control v6.0 in a database
(COMDLG32.ocx) and have found that some users do not have this OCX file on
their PC so I have to copy it to \windows\system32 then run regsvr32 to
register it.....I would like to automate this within the app.
So, I created a table and can insert the control in the table and my code
can run regsvr32 but how do I actually copy the file from the table to that
directory on the PC? Is there another way to store a file within the database
so it can be copied to the PC?

Reply to this Message

Ron Weiner - 05 Aug 2005 12:04 GMT

Ricardo

If I were you I would "loose" the MS Common dialog Control and use the all
API solution described here:

http://www.mvps.org/access/api/api0001.htm

It works 100% of the time, there are no versioning problems, and will
alleviate you from the angst of having to store files, copy files, and make
changes to the users registry. In short it is the preferred solution for MS
Access file Open/Save.

Ron W
www.WorksRite.com

> I am using the Microsoft Common dialog control v6.0 in a database
> (COMDLG32.ocx) and have found that some users do not have this OCX file on
[quoted text clipped - 4 lines]
> directory on the PC? Is there another way to store a file within the database
> so it can be copied to the PC?

Reply to this Message

Ricardo - 12 Aug 2005 04:34 GMT

Ron, brilliant thank you.

> Ricardo
>
[quoted text clipped - 20 lines]
> database
> > so it can be copied to the PC?

Reply to this Message

Paul Overway - 05 Aug 2005 12:47 GMT

You're using circular logic. The reason I say that is you probably have a
reference set to the control in your app, but if it isn't installed your app
will be broken because of the missing reference and therefore unable to
install the OCX. The OCX needs to be installed by a proper installer
OR...and this is the better solution...don't use the OCX at all, but use an
API function instead.

Signature

Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

>I am using the Microsoft Common dialog control v6.0 in a database
> (COMDLG32.ocx) and have found that some users do not have this OCX file on
[quoted text clipped - 6 lines]
> database
> so it can be copied to the PC?

Reply to this Message

nelsonsoft@hotmail.com - 08 Aug 2005 21:47 GMT

As another option you can take a look at FilePush as www.nssdd.com. It
will push the file out and register it on the remote workstation using
your user rights. So if your end user does not have rights to register
controls you can still do so remotely.

Gil

> You're using circular logic. The reason I say that is you probably have a
> reference set to the control in your app, but if it isn't installed your app
[quoted text clipped - 18 lines]
> > database
> > so it can be copied to the PC?

Reply to this Message