Monitoring CTRL-ALT-DELETE activity

[andrewf10]

Hi,

This is a long shot but anyway...

Because of the number of times my database has crashed lately, I have a feeling that some new users are exiting it using the evil CTRL-ALT-DELETE method (possibly because their PC isn't up to the job).

Assuming that there's no way of stopping this, is there any way Access can record this data so I can check afterwards who it was?

My database has full security with all users having unique logons. Each user has their own PC and doesn't log on to any other.

Thanks in advance

 

[ghudson]

I am not aware of any routines that will track if a user presses the Ctrl + Alt + Delete keys. Since you are using security, you could create a routine that will track when a user opens the db and when the user closes the db. If the user successfully closes the db then you should be able to track when they exited the db.

You should take the time to educate your users as to why they should never use the Ctrl + Alt + Delete keys to exit the db. The Ctrl + Alt + Delete keys are a db killer and you just might not be able to repair the db if one too many users Ctrl + Alt + Delete the db just to exit it. I would also find out why they are using the Ctrl + Alt + Delete keys to exit the db. If their hardware is not up to par, recommend an upgrade and justify it by explaining your db could be corrupted beyond repair.

HTH

 

[andrewf10]

Thanks for the reply GHudson.

I've tried every possible way of education, then used threats and finally, after the database packing it in last week (beyond repair)as you expertly warned, I'm looking for other methods to avoid this.

The best I've been able to do so far is keep a record of who is/was logged on at the time of the crash and see if a pattern develops. Because there are 25 users, I will need to be sure who my problem users are before I can go and request hardware upgrades.

Either way, I will have a go at creating a routine which will tell me who has logged off successfully.