[AccessD] Access error - A problem occurred while Microsoft Access was communicating with the OLE server or Active X Control.

 Go into VBA, tools/references.   Check any un-checked reference (doesn't
matter which), close the DB and Access.  Re-open and un-check the reference
just checked (will be the last one).

 Now compile, save, and close. Re-open and see if you have the same problem.

 If so, are you using DAO?  It may need to be re-registered.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Friday, September 20, 2013 02:39 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access error - A problem occurred while Microsoft Access
was communicating with the OLE server or Active X Control.

Folks,

This is driving me nuts. I created a new Access 2010, accdb database.
Created some tables. Created one form with one table as the recordsource.
The form has a total of 269 controls on it, labels, text boxes, etc. There
is no code on the form aside from a close button that runs 'Docmd.close'.
When I attempt to close the form using the button I get an Access error " A
problem occurred while Microsoft Access was communicating with the OLE
server or Active X Control.". The error is thrown before the code runs.
Can't catch it with a break point. If I substitute a macro it closes fine.
What can be causing this? I have compacted, decompiled/compiled/compacted,
imported into a new database container, exported form to text and
re-imported and still get the error. Tried putting the file on another
computer to see if my version of Access corrupted somehow. Get the same
error there.

Looked in this form and general Google search and cannot find a cause. Any
good ideas. I need to be able to put some VBA behind this form.

Thanks in advance.

Doug

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com