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.
I know this isn't very clear, I'm getting a bit stumped, any questions then ask me.