I have an MS Access application, running on a very locked down 2012 R2, RDP server. If an issue occurs that can't be handled by the Access application a user message pops us with one of the options being to log-off. However, I had an issue yesterday, where something happened and Access just exited, but it left the user with a black screen requiring another user with Admin rights to log them off through the Task Manager. I need this to be handled without Admin involvement.
I was thinking of writing a small c# app that is loaded by the Access application on startup. My idea was to pass it the ProcessID through a command line switch, and then have the app monitor the PID every 30 seconds or so. If the PID disappears (ie, Access has crashed out), it simply logs the user off. However, resources on the server are tight, so I'm trying to find the best method.
Is this a good idea, or is there a better way? Also, if anyone has any code suggestions, that would make my life easier.