ActiveX Reference

[damian]

Upon loading and referencing an ActiveX object in the VBA window, I've tried to change the location of the object in the Tools ] References list by browsing to another version of the object in a different folder. However the location details always revert back to the original location no matter what I try - is there an entry in the registry of my PC that requires deleting/editing?

 

[Galaxiom]

Don't know much about this kind of thing but I do know ActiveX components need to be registered. Perhaps the reference in Access automatically reverts to the path of a registered version if you point it to a file that is not registered.

The program that registers them is called regsvr32.exe
It is used in a command line with the argument being the path to the file to be registered.

 

[vbaInet]

It could also be an idea of renaming your activeX object. Maybe you've used a reserved name.

 

[damian]

Thanks for the feedback - still struggling. Tried running regsvr32.exe but only greeted with an error message.

Also, I haven't used any reserved names etc

 

[vbaInet]

Just a shot, are you running two versions of Access on that machine?

 

[Max D]

Why do you need to change the path? Because you have 2 versions of the same ActiveX? Its not allowed, because ActiveXses are registered in Windows - one record per one ActiveX name.

If your ActiveX file have moved, you need to reregister it.

To register activeX you need to install it, if it have an installation file. If you have an OCX file only, do

regsvr32 c:\somewhere\myactiveX.OCX

 

[Galaxiom]

Dependency Walker is a useful free tool for diagnosing registration errors.
http://dependencywalker.com/