?
Solved

Error 80010108 Automation Error

Posted on 2003-03-05
13
Medium Priority
?
4,810 Views
Last Modified: 2007-12-19
I'm getting an error on a programme I'm working on, details as follows:

Error message: 80010108 Automation Error The object invoked has disconnected from its client.

I'm using Access 2000, the error does not occur on my PC (Win 2000), however on three other PCs, 1 using win 2000 other 2 using XP the error occurs, sometimes when programme is left for a while, sometimes when programme is being used, there seems to be no pattern. We are using class modules within the exe file, the error occurs when running the exe on the XP machines, and at run time within VB on the 2000 machine.

I have tried making sure all recordsets are closed when they are finished with, the issue does seem to be an issue with access 2000. At first I thought it was a timeout issue, but it also occurs when the databse is being accessed.

Any ideas?

I know this isn't very clear, I'm getting a bit stumped, any questions then ask me.

Chars

John
0
Comment
Question by:jward1980
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +3
13 Comments
 
LVL 27

Expert Comment

by:Dabas
ID: 8071016
You say that it can happen within VB.

In that case you should be able to see which line in your code is causing the problem????

Dabas
0
 
LVL 1

Author Comment

by:jward1980
ID: 8071037
Sorry no I forgot to mention, when this error occurs, VB crashes and I am unable to view the line of code it is occuring on :(
0
 
LVL 27

Expert Comment

by:Dabas
ID: 8071085
When I have a situation like this, I make full use of the status bar in Simple mode.

Before any action, I make sure I display a short description of what I want to do in the status bar, such as "Opening Recordset...." or "Waiting for user input...", etc

Not only does this automatically provide comments to your code, it also gives feedback to the user, AND most important, helps you out in situations like yours.

When the message appears, in most cases the application is still visible and the status bar is not covered. You will be able to at least see what the last message was, which in turn can give you a clue as to where to look for the culprit code...

Hope this helps!

Dabas
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Expert Comment

by:supunr
ID: 8071355
Before you do anything with the recordset, make sure that the recordset is open.  If it is closed, then call the subroutine to reopen the same recordset.

eg.

Private Sub SomeSubroutine()
    If (rsRecordset.State <> adStateOpen) Then
        Exit Sub
    End if
End Sub
0
 
LVL 5

Expert Comment

by:RainUK
ID: 8071371
alternatively just write some code to do a text file log as it goes through the subroutines. That way you have more of a definite log. You could get a product something like NuMega Tools failsafe, which can automate all that for you.

Or simply add line numberes and then use the function Erl() , when an error occurs dump to the event log e.g. App.Logevent. You will have to add the error handler in the routines which have the object accessed.
0
 
LVL 1

Author Comment

by:jward1980
ID: 8078694
The only problem I have with displaying a short decription or checking the recordset is open is that I'm working on a programme with 117 forms and about 550 recordsets, it could take quite a while, we launch the programme in a month, I was just wondering if anyone had had this problem, however I will try NuMega and see if it works, I'll get back to you
0
 
LVL 5

Expert Comment

by:RainUK
ID: 8078716
Buying NuMega Tools in this case will be worth it!
0
 
LVL 1

Author Comment

by:jward1980
ID: 8903667
Hi, this problem is still a problem, we've figured that it's a problem connecting into access, however it can't be that the connection to the db has timed out because I have a timer accessing the database every minute, the other thing that may be causing problems is the ODBC link into sage, however this is also being accessed every minute, I'm totally lost, Help!!! PS I am increasing this question to 545 points
0
 
LVL 1

Author Comment

by:jward1980
ID: 8903684
Sorry, check that 500 points, can't do any more
0
 

Expert Comment

by:CleanupPing
ID: 9056545
jward1980:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 27

Expert Comment

by:Dabas
ID: 9056556
CV, Mod:
Recommend PAQ/Refund

Dabas
0
 
LVL 1

Author Comment

by:jward1980
ID: 9062221
Hi, am posting notification of intention to request refund on this question, thanks for trying but this problem still exists, thanks
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 9064364
User resolved; points refunded and question closed.

Netminder
EE Admin
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month9 days, left to enroll

764 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