Solved

Automation error 440

Posted on 1998-10-16
1
233 Views
Last Modified: 2008-03-10
In an Form-open routine I receive the mentioned message.
It happens rarely. What is the reason, and what can I do ?
0
Comment
Question by:skyberg
1 Comment
 
LVL 1

Accepted Solution

by:
aumdavis earned 30 total points
ID: 1965617
Microsoft gives the following reason for this error:

OLE Automation Error 440, an error that occurs when an OLE Automation server times out or is not ready to accept a particular command

To debug the error, first try removing your Form-open code and see if the form opens OK without any code running.  If so, you should then step through the code as the form opens and make note of any commands that take a long time to run.

In this way you can identify where the form is timing out.

A second option would be to try to re-install Access--this was given as a possible solution on the Microsoft site.

Good luck!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now