[AccessD] Shutting Down Memory Process?

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-----



More information about the AccessD mailing list