G'day All.
We have created an Custom ActiveX Library (DLL) in VB6 and wish to call functions in this library from VBA.
This works perfectly on my machine but when distributing the application (MDB) to other machines we get an
429 Cannot create ActiveX component error.
I have traced this error down to what I think is the security features of Access 2003. Once we registered with Access it works perfectly.
The Component is referenced and registered on the machine but will not execute until this Access registration is complete.
Is there any way of automatically registering this component for ease of distribution?
Thanks in advance.
We have created an Custom ActiveX Library (DLL) in VB6 and wish to call functions in this library from VBA.
This works perfectly on my machine but when distributing the application (MDB) to other machines we get an
429 Cannot create ActiveX component error.
I have traced this error down to what I think is the security features of Access 2003. Once we registered with Access it works perfectly.
The Component is referenced and registered on the machine but will not execute until this Access registration is complete.
Is there any way of automatically registering this component for ease of distribution?
Thanks in advance.