Run-time error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients.
What to look for to fix?
Printable View
Run-time error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients.
What to look for to fix?
Do you know where in your code it is occuring or what is happening at the time? That's what to look for first.
I am nowing running non-compiled code so i can see where it is when it fails.....
Post the code and what is failing...
Non-compiled code ran all night with no issues, not sure if it just needs time to fail or only the executable dies.
It sounds like you don't have any error handling going on or you would not have this big question mark. I suggest you add some and as long as you are at it do it everywhere. There are a lot of approaches but here is one I use:Quote:
Originally Posted by brian goodwin
1. At the top of each procedure add the "on error goto ErrorHandler"Code:Private Sub Command1_Click()
10 On Error GoTo ErrorHandler
Dim x As Long
20 Debug.Print ("Line of code for demonstation of executable statements")
30 Debug.Print ("Line of code for demonstation of executable statements")
40 Debug.Print ("Line of code for demonstation of executable statements")
50 Debug.Print ("Line of code for demonstation of executable statements")
60 x = x \ 0
70 exit sub
ErrorHandler:
MsgBox "Error occured in form1 - Command1_Click - line " & Erl & vbCrLf & _
"Error Details: " & Err.Number & " " & Err.Description
End Sub
2. At the bottom add the error handler.
3. Include the "Exit sub" so the code does not fall into the error handler.
4. Get MZTools from here. It is free. http://www.mztools.com/v3/download.aspx
5. There is an option to add line numbers to your project all at once. It will also remove them if you don't like them.
Then when your code hits a run time error it will display:
1. The routine where it happened.
2. The line number where it occured.
3. The error messgae.
It is up front work but it will save you lots of headaches down the road.
Some people take different actions in the error hander routines like logging to a file pertinamt information. With my approach it is more basic but you would not be guessing like you are now.
yes, i also agreed with Tyson .you need to use error Handler at each of your Method and Functions .
The whole code seems to be unstable? The program crashes just fooling around with the ide version. Is there a way to re-create the frmmain.frm file? Is there a way that this file can get corrupt? I can put all this error handling in but if it is unstable as an ide version I don't think it will tell me anything?
as i have been seen . you did not post any code till now . better if you will post some of the code .we will give more
useful suggestion .
You aren't helping yourself by not providing information for us to help you.
1. The whole code seems to be unstable?
What's that supposed to mean?
2. The program crashes just fooling around with the ide version.
What's that supposed to mean?
Look at it this way. If I walked up to your desk and said "The whole code seems to be unstable? The program crashes just fooling around with the ide version." what would you ask me?
You would probaby also say "show me what you mean". Tell us and show us what you mean. :confused: