Relative addressing of ActiveX control

[NDayave]

Hey,

I was wondering if there was a way to relatively address the location of a .ocx activeX plugin that is embedded in a form.

I want to have the plugin embedded on a form, in a database that is going to be moved around very frequently on different computers- The details of this are inconsequential , there is no way for it to not move - so everything it needs has to travel with it.
For example, pictures are stored in a folder next to the access file and addressed in relation to the application.

Is there any way to do this with an ActiveX control, as no matter where I install it, it is absolutely addressed by Access. (eg. "C:\Documen ts and settings\etc").

Thanks in advance,

Dave

[nico5038]

In general this is done by creating a package. There the needed .dll's can be added and will be installed too.
A2000 professional will allow you to create such packages, A2003 and + will require the VB installer.
There are however also many other free package solution that will do the trick.

Nic;o)

[NDayave]

There are however also many other free package solution that will do the trick.

Could you point me in the direction of one you would recommend? I have had a look around and can only find non-free solutions or illegal versions of the non-free solutions.

Thanks,

NDayave

[nico5038]

Checkout http://en.wikipedia.org/wiki/Windows_Installer

Nic;o)

[NDayave]

Ah, cheers for that. It would appear all I need now is the Access 2003 Runtime. That cost much?

[nico5038]

That's for free and can be downloaded from the Microsoft site.

Nic;o)

[NDayave]

You're just out to make me look stupid aren't you? I can't find that either. And I looked for aaaages. The only thing I could find was:

"Even though the runtime software is included in the Microsoft Office Access 2003 retail product, the right to distribute the runtime is not included. You must purchase the Access 2003 Developer Extensions to obtain a royalty-free license to package and distribute the runtime."

Which is from http://office.microsoft.com/en-us/ac...208861033.aspx

With regard to the Developer extensions, they seem to only come with Visual Studio and a load of bundled software pushing the price far outside of my budget.

[nico5038]

Looks like Microsoft stopped distributing the A2003 runtime, but the A2007 runtime will run A2003 mds's too so checkout:
http://www.microsoft.com/downloads/d...6-2c745a175aed and see that the runtime is free of copyright.

Nic;o)

[NDayave]

Thanks for that, when I get around to packing the database you can be sure i'll be back here if any problems arise.

Keeping you on your toes and all that xD