Several MS Access databases working on one computer and they don’t work on another.
The error message belongs to the forms of the database.
When you click on a button, MS Access gives this error message:
Error communicating with the OLE server or ActiveX Control
The error is generally caused by the use of special characters in object names.
When you create a form in Hungarian or other localized Access you will see, that the objects on the form get problematic names (Labels – Címke, Header – Űrlapfej, Footer – Űrlapláb, Combobox – KombináltLista etc.)
The solution:
1. You have to rename the special named objects on the problematic form.
2. If the error remained then create a new mdb file and import all objects from your old mdb.
This happended to me shortly after I shut down serveral WinXP_32bit services via Administartive Tools; unfortunately, I didn’t record which services I shut down not now I’m having to guess which one needs to be started back up.
I found the service.
When I turned the
“COM+ System Application”
service back on. The error message went away.
Best,
Shawn
Hi, nice post. I have been thinking about this issue,so thanks for sharing. I will definitely be subscribing to your posts.
I get this error upon opening MS Access and tried both solution s previously listed but still no luck… Office XP sp3….. any thoughts?
Danny: Try to decompile: http://www.granite.ab.ca/access/decompile.htm
Danny: This can help also: http://www.utteraccess.com/forums/printthread.php?Board=83&main=1122452&type=post
This happended to me shortly after I shut down serveral WinXP_32bit services via Administartive Tools; unfortunately, I didn’t record which services I shut down not now I’m having to guess which one needs to be started back up.