ChampionDuy
Registered User.
- Local time
- Today, 14:00
- Joined
- Mar 14, 2002
- Messages
- 94
I have a table that lets me know what users are loged into my database. In that table whenever a user logs in, the YES/NO field for that user changes from a No to a Yes.
I need that field to return to a NO, whenever that user exits the DB.
I have a button that I have told all users to use to Exit the DB. This button exits the DB and runs a query that changes the field to NO.
However we all know users, and they rarely do what is told. And if they wanted, they could still go to File, Exit. (Unless someone could tell me how to get rid of that) Or they could still click on the "X" in the top right hand corner. (Unless someone could tell me how to get rid of that) How can I either force them to use the Exit button, or have that query run whenever a the DB closes.
Is there a DB close event?
Where would I put the code to run the Query?
I need that field to return to a NO, whenever that user exits the DB.
I have a button that I have told all users to use to Exit the DB. This button exits the DB and runs a query that changes the field to NO.
However we all know users, and they rarely do what is told. And if they wanted, they could still go to File, Exit. (Unless someone could tell me how to get rid of that) Or they could still click on the "X" in the top right hand corner. (Unless someone could tell me how to get rid of that) How can I either force them to use the Exit button, or have that query run whenever a the DB closes.
Is there a DB close event?
Where would I put the code to run the Query?