Error when inserting ActiveX control

Question

Hi

I am working in Microsoft ACCESS 2010 and trying to insert an activeX control in a Form but it is showing error that "The operation on the OLE object  failed. The OLE server may not be registered. To register OLE server, reinstall it". 

I tried to reinstall MS ACCESS and MS OFFICE 2010, repaired MS OFFICE 2010 but still issue is same.

Please give me some suggestion/solution for this issue. Thanks in advance.

Answer 1

There are various ActiveX controls are available in MS ACCESS 2010.

There are quite a few listed, but just because they're in the list does not mean they are compatible with Access. That listing shows any ActiveX that's been registered on your system, regardless of whether it's compatible or not. Use the native controls, or switch to an environment that provides you with a wider variety of 3rd party controls (like one of the .NET languages).

Also understand that using ActiveX controls comes with other issues as well - for example, if you're going to deploy this to end users then those users will have to have a compatible environment (i.e. the same version of the control installed and registered on their system, etc etc). All in all, trying to use incompatible ActiveX controls in Access is not something that I've ever recommended.

Answer 2

I don't know what Tools section you found But if its the one in the Visual Basic Environment you would see the References option.

In any case, I suspect you came from a programming environment that uses a lot of external controls and objects. That is not as necessary with Access as it has almost all the built in controls and objects you need. If you want to add a checkbox to a form, you can do so using the Control Toolbox on the Design ribbon when in Form Design mode. That toolbox has most of the controls you will need.