About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
I am (still) developing with VB 6.0 and MS Access 2000 on Win98-R2.
When my application runs on WinXP machines, it occasionally gives the following ADO error message:
Automation error. The object has disconnected from its clients.
I have no idea what is causing this. It has never occurred on my Win98 machine.
The application opens three ADO database connections (to different databases) on startup. It is not supposed to close any of the connections until shutdown.
The error has occurred only a few times within the last month or so. It seems to happen when the application is left running for more than an hour or two with no user activity.
Any ideas on what is causing this and how I can fix it?
Thanks,
Joe
Answer Hi
My first thought here is that the libraries are in conflict in some way.
When deploying away from your Win 98 machine do you use a set up package? Registering the DLLs may help with this problem.
Ultimately the trouble is that Win98 isn't stable. So just because your software works on that platform doesn't mean it will work on another.
