Robert
robert at servicexp.com
Sat Mar 15 10:26:33 CDT 2008
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello All, I'm having a problem that I just don't understand. A2002; Split db I have a few clients that intermittently experience a MS Access Crash, where the "Access" error reporting system activates, and then the program shuts down. ~ This is the part I don't understand. Sometimes when this happens, the "access.exe" process will still be running in the background. How is this possible? I understand when access.exe crashed, my code to close objects and such isn't run, but if access.exe is crashing wouldn't it destroy those objects?? The problem for the client is, if there is a access.exe process still running on one of their machines, they cannot backup the database on the server. They have to go to each machine and close the process on the offending machine. OK MY REAL QUESTION: ;-) Anyway I have put together some code, from various places (http://mvps.org/access/api/api0041.htm & http://www.visualbasic.happycodings.com/Windows_and_Controls/code44.html) ~ to look for and shut down another instance of my program running. The code works perfectly on a running program (where it's listed in the applications tab of the Task Manager)but I don't know if it will work on just a process running? I have tried for the last hour to close my program leaving objects unclosed to get the access.exe process to hang but no luck.. Does anyone know if this will also work on an open access.exe process? Sorry for the long version.... WBR Robert -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFH2+qp72dSYCwH8FQRAg1BAKCjWO+0r1AhqVQ252V5MsyKaUnTEACgxlhL BKC5eb0EIYsrHPHvVrWXztk= =NwGn -----END PGP SIGNATURE-----