Run-time error '-2147417848 (80010108)':Automation error.The object invoked has disconnect

Hello everyone

I have a shared excel file that serves as a department database, and it has a userform that allows users to search staff details and create new password. Also, the userform allows the admin team to edit, add, or delete staff details in the database using an admin password.

This file is working well on my laptop. However, when I started using this in a network shared drive, it started giving this Automation Error in several functions. At first, it appeared when closing the userform that triggers the Activeworkbook.Close command. Then, after I changed it to Thisworkbook.Close, the Automation Error went on to searching a staff details, and even on ActiveWindow.DisplayHorizontalScrollBar. But what's driving me crazy is that after I specified the particular workbook & worksheet for each range or cell commands I used, the Automation Error still occur and it's an intermittent thing.

Can someone please,please try to explain why this is happening? Is this a code or network error, or excel sharing conflict, or an excel bug?

Since the error appeared almost everywhere on my code, I just pasted a sample code I already revised yet with intermittent error when executed.

Please Login or Register  to view this content.

Thank you so much for all your time to help.

hydz1213

Thank you so much ExcelTab for your time and reply

I haven't thought of using another language in my macros. Your suggestion really seems to be a good way to go. I actually prefer using ms access for this instead of excel but all our user's desktops doesn't have ms access installed so i remained in excel.

With your suggestion, since i'm not particular yet with sql in vba, can you point me on the right direction where i can read guides or tutorial about this?

I would really,really appreciate it!

hydz1213

Originally Posted by JosephP

with a shared excel workbook you're likely in for a world of trouble no matter what

Hi JosephP

Thanks for the correction. I'll check on that one. Also, any suggestion I can use or do in order to make this file effective for multiusers even without sharing it?

The thing is, since it's a staff database, they need to have the capacity to search their names & change their passwords in it. And just to add, this database is linked to 2 more excel files (A & B for example) that whenever they open A & B files and enter their staff ID#s, the database will temporarily open & search their details then populate them in certain cells in A & B workbooks.

I'm really hoping you could suggest another way.

Thanks again!

hydz1213

I guess your're both right!

I'm thinking to just create a local excel file for each users and incorporate a code I just found that will transfer data from excel to access dbase whenever there's a change on the file. My only problem with this is it copies in bulk. I need to find a way to use the SQL INSERT statement properly.

But anyway, thank you both for your contributions on this. I really appreciate the ideas!

Til next time!

hydz1213