asked on

Late binding to an object through and MDE file

I have an Access database that uses two objects by third parties. The “main form” for the database is where both objects reside and they have references set for both of them (pointing to an .ocx file), via VBA, References. At present the location of the .ocx files is "C:\Program Files\CompanyName\AppName\Third Party Drivers", but there is a chance that this may need to be changed in the near future perhaps "C:\Program data\..." or "E:\Something\...".

I know that I could open up the master databases for each installation, but I really want to avoid having more then one master database to manage.

I am speaking with the software companies, but I need to explore all options. If I could somehow set the ocx locations for these controls with the main form is loaded (even in an MDE file), that would be the best solution for me.

Don't know if there is any way, but any help would be appreciated as always.

ASKER CERTIFIED SOLUTION

YohanF

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andy Brown

ASKER

Ahhhhh - interesting, so that should work with an MDE file?

YohanF

yep, it does.. thats what I did and makes the life very eacy. What I also did what when I am distributing files I copied all the ocx and reference files in to a folder in the same place as MDE and make sure I refresh teh references every time user load teh software.

i.e.- str = CurrentProject.Path & "\references\test.ocx"

and teh good point is, this will only refresh reference if it is missing...

Andy Brown

ASKER

As sad as it sounds - that's the best news i've had all day.

Thank you - very much appreciated.