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.