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

Doug Murphy dw-murphy at cox.net
Fri Sep 20 16:44:15 CDT 2013


Found the problem. This application is for gathering and reporting on the chemistry in a water plant. The client gave me an excel file of the data they collect. I linked to the file and created a table from it. One of the fields had the character ∆ in the name. That is what was causing the problem. Thanks to your questions I took out half the fields and then started adding them back until I got the error. Good to have some outside thoughts.

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

This form has never worked. I am thinking it has something to do with the number of fields in the data source or on the form. Will see what happens as I add more and more fields to the form.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, September 20, 2013 1:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access error - A problem occurred while Microsoft Accesswas communicating with the OLE server or Active X Control.

Was it working before and now it's not -- for no apparent reason.

Susan H.


> 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

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

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




More information about the AccessD mailing list