Home | Software | Microsoft Office | Microsoft Access | A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control

A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control

If you are using Microsoft access and you get an error such as the picture below you know that the source code in your form can never run. You must have discovered that other forms have their codes running but a particular form keeps giving you errors. One critical error I discovered recently while developing a database using Microsoft Access 2016 is the error that displays:

The expression on click you entered as the event property setting produced the following error: object or class does not support the set of events.

Such error is sometimes caused by a library local setting on your pc especially when you get the database from a different source or due to the use of unicode symbolic characters. In this particular case after so many hours to debug what the problem is I had to go for online resource to know how to get such code error fixed.

So what I had to do was to look for what the problem is by deleting each control on my form until i discovered the problem was actually from unicode character symbol for male and female which was attached to both the label and the control programming name and after changing the name everything was fixed I really like you to watch the video attached to this particular article so you get a better information about what I had to do to get this fixed. If you have more suggestions on how you got yours fixed, don’t hesitate to share it at the comment section below this article.

Other Resource

Site 1: Suggested setting your Locale language settings in which the database was created.

https://social.technet.microsoft.com/Forums/en-US/9c7cad5c-3b6f-4864-964d-5a38bc00e775/a-problem-occured-while-microsoft-access-was-communicating-with-the-ole-server-or-activex-control?forum=Office2016ITPro

Site 2: Suggested you delete the Cached files.

https://answers.microsoft.com/en-us/office/forum/office_2013_release-access/problem-communicating-with-ole-server-or-activex/ec639e01-25c7-4cd2-bb36-a19a3655e4a4

Share with friend(s)

One comment

  1. Excellent! You saved my time!!! Setting for Non-Unicode language solved this problem.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.