I would like something that when i press a button it will send a message and tell them that they need to close the database
IE: if user1 = true then
msgbox "Please close the database"
end if
I would like something that when i press a button it will send a message and tell them that they need to close the database
IE: if user1 = true then
msgbox "Please close the database"
end if
Use an instant messenger or email.
I tired this:
I have a tConfig table, in it are various field used to configure the db, and 1 is Shutdown (t/f)
when a user closes a form it checks, tConfig.Shutdown if true, then posts the message and quits.
the only downside, you must put the Check4Shutdown() routine in many places....
in the FormClose, when they close a form,
in the menu button click, so they dont start any more operations,
and in any more places you use.
If they sit on a form and/or do nothing , they wont get any message.
Code:sub Form_close() Check4Shutdown end sub sub Check4Shutdown() if Dlookup("[ShutDown]","tConfig") then msgbox "shutting down" docmd.quit end if end sub
Last edited by ranman256; 05-23-2017 at 06:08 AM.
Here's a site with a number of examples for doing this kind of thing:
Kick Users Off - Detect Idle Time
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Can we assume this is a properly split database with each user having their own (not shared) copy of the front end?