In some of my applications I keep track of both when a user logs in to the application and when the user logs out. The theory is that I will know who is actually currently logged in to the application.
Unfortunately, this only works when the users close the application by selecting the quit button on the main menu. (I’ve disabled the control boxes on forms.) If a user clicks on the close X for the Access window, the application also closes but the application is not aware that the user has selected close and, as a result, does not change the user’s status to “not logged in”.
How can I either (or both):
1. Disable the close window button and/or control box on the Access window.
2. Sense that the user has clicked the close window button for Access in my application and perform the table update to change the user’s status before the application and Access actually close.