Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4899
  • Last Modified:

Error 80010108 Automation Error

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
jward1980
Asked:
jward1980
  • 5
  • 3
  • 2
  • +3
1 Solution
 
DabasCommented:
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
 
jward1980Author Commented:
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
 
DabasCommented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
supunrCommented:
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
 
RainUKCommented:
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
 
jward1980Author Commented:
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
 
RainUKCommented:
Buying NuMega Tools in this case will be worth it!
0
 
jward1980Author Commented:
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
 
jward1980Author Commented:
Sorry, check that 500 points, can't do any more
0
 
CleanupPingCommented:
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
 
DabasCommented:
CV, Mod:
Recommend PAQ/Refund

Dabas
0
 
jward1980Author Commented:
Hi, am posting notification of intention to request refund on this question, thanks for trying but this problem still exists, thanks
0
 
NetminderCommented:
User resolved; points refunded and question closed.

Netminder
EE Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now