Microsoft Access: A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control: Error Message 502473

Question

Hi Everyone!

I have received the following message when I tried to run my VBA code after a button On Click event:

"A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control."

Before I did so, I changed from the original default setting (linked to a macro) to linked to vba code. It kept on showing that I have this OLE Server/ActiveX error. I have tried changing the non-Unicode settings on my computer. However, the message pops back up again.

The funny thing is, when I tried to change back to running a macro and Access would run it. Moreover, my name of my sub is generated by Access itself (e.g. Private Sub Command1_Click() ). Thus, I have ruled out the possibility of Access not being able to find the sub.

I have been through all the forum threads but I still haven't found a solution to solving my error.

I am currently running Office 2010 on Windows 7 on a brand new computer.

It would be great if anyone can help me out on this one!

Thanks!

Answer 1

Hi,

What exactly do you mean by

>  I have tried changing the non-Unicode settings on my computer.

?

What language version of Windows and Access do you use?

The cause for this problem often are special characters (accents etc.) in names of objects, sections, controls, property settings etc.: http://support.microsoft.com/kb/907337/en-us

Hi Karl!

Thanks for the reply! I think I have found a way to fix the problem. What Access did was very strange. The reason I say this is because this error did not appear when I create another button on another form in the same Access file. So I just moved everything to that new form.

What I did before was trying to change the non-Unicode Language settings in Controls Panel under Regional Language.

But anyhow, it works now. So thanks for helping out :)

Answer 2

Hi,

What exactly do you mean by

>  I have tried changing the non-Unicode settings on my computer.

?

What language version of Windows and Access do you use?

The cause for this problem often are special characters (accents etc.) in names of objects, sections, controls, property settings etc.: http://support.microsoft.com/kb/907337/en-us