Communicating with the OLE Server or ActiveX Control

ms-access activex ole
StuckAtWork picture StuckAtWork · May 17, 2012 · Viewed 28.5k times · Source

MS Access 2010, Win 7 on a regular form
I didn't intentionally place any ActiveX or OLE things.. not even sure what they are. But anyways, whenever I put something in the code of a particular form, it says
"The Expression XXXXX you entered as the event property setting produced the following error: A problem occured while MyDB was communicating with the OLE server or Active X Control

Huh? No matter what I put in the form's code, this happens. I had an empty Form_Current() ONLY which still tripped this. There's a lot of formatting and work into the form, I'd rather not scrap it.. If I leave the code window completely empty (only Option Compare Database), it does not trip the error; however then my form is useless.

I've seen things about this being a language issue, but my other forms (running the same code techniques and most of the same code) are fine and it's an english Access with an english language PC. Ideas?

Code setting off the error:

Private Sub Form_Current()
End Sub

Seriously.

Answer

Abu Hassan picture Abu Hassan · Mar 30, 2015

I faced the same problem and I tried many things, the only (and fastest) solution that worked is to do the following: 1) Close the form that is causing the error. 2) Rename this form. 3) Duplicate it: Copy, then Paste, you will be prompted to set a name for the new form. Give it the original name. 4) Delete the original form that was causing the error. 5) Open the pasted form and it will work OK. This solution worked fine with my database... Regards...

Related questions

Read and write to an access database using Javascript

first I want to mention that I am aware that in web interaction with databases should always be with server side languages due to security reasons and for the fact that javascript as is doesn't offer and compatibility with the …

Read More
VBA With Microsoft Access - Check if object exists

I'm using VBA with Microsoft Access. I'm setting an object to an item inside a WebBrowserControl that sometimes exists, sometimes doesn't. Dim myWebBrowser As Object Dim myItemInsideWebpage As Object Set myWebBrowser = Me.WebBrowser0.Object Set myItemInsideWebpage = myWebBrowser.Document.GetElemendById("myDiv") …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More