I have an xls file that is executed by more than one user (a maximum of ten usually).It contains a form with a button and in the onclick event of that button the following code executes:
It stops with the following error (sometimes)
Run Time error - 2147467259 (80004005)
Record is deleted
I didn't write the code but it is executing fine when there is only one person. The problem is that everone is accessing the same xls file (on a mapped drive) and it can't handle too many users (the database it is accessing is also on a mapped drive).
Can anyone suggest a solution to this?
Thank you for any replies
Bookmarks