How to register a .OCX file...

DT

Registered User.
Local time
Today, 07:35
Joined
Oct 23, 2000
Messages
83
I need to distribute and register an .OCX file across our network. Is it possible to do this in Access (we are using Access97). I am hoping I don't have to go around to each machine (150+) and register the file thru the Regsrv32.exe command. Any help on this would be much appreciated.

Thanks,

Derek
 
Well, the good news is, you can do this from VBA code. The bad news is, if the product is already distributed and installed, it is already too late.

Look in the Help files for the registry topics, which will lead you to routines with names like GetSettings, SaveSetting, GetAllSettings, DeleteSetting. These are the functions and procedures you call to do the job from VBA.

You might also be able to do something using RunCommand to activate a Menu Bar option.

Beyond that, I'm not sure what else you could do. Except maybe distribute the files over your network and send out instructions based on the user manually using the Tools>>Active X dialog box to register the controls you want. If your users are not the administrators of their own systems, however, this might not work. But then, in that case Access running under their accounts wouldn't be able to do it either.
 
Last edited:
I think I got it! I just tried to register the file thru a macro and it worked great! Now I'll test this on some other machines.
 

Users who are viewing this thread

Back
Top Bottom