Send Message Box to Users Logged in

  • Thread starter Thread starter amanda_jb
  • Start date Start date
A

amanda_jb

Would anyone know if there is a way to send a message box of sorts to users
that are currently logged into the Database?

I currently send emails giving them log out times, but continually have to
log onto the server and kick out those who didn't read the email (then they
have to go through the headache of the network error messages trying to get
their Access closed). I thought it would be so much easier if they could
just get a pop up while they're working in it. I was hoping if I have a
pre-set message, there might be the possiblity???? I would appreciate anyones
help!!!

Thank you!
 
amanda_jb said:
Would anyone know if there is a way to send a message box of sorts to
users that are currently logged into the Database?

I currently send emails giving them log out times, but continually have to
log onto the server and kick out those who didn't read the email (then
they have to go through the headache of the network error messages trying
to get
their Access closed). I thought it would be so much easier if they could
just get a pop up while they're working in it. I was hoping if I have a
pre-set message, there might be the possiblity???? I would appreciate
anyones help!!!

Thank you!
Click to expand...

Usual approach is to have a form's Timer function (a form that is
always open) check a table at a set interval. When something is found
in the table "do something", otherwise do nothing.

For example, you enter into the table the text "Please log out of the
database" and on the next timer interval you use a form to display
that text to the user.

If you also want to have that trigger a count-down to an automatic
close of the app make sure you don't use a MsgBox or a dialog form as
that would prevent any more code from running if the user happens to
be away from their desk or otherwise does not see the message.
 
Rick's approach will work both in split Access - Jet/ACE workgroup
databases, or in Access client apps to Server database back ends. I've used
the technique to pass administrative messages to active users, to warn them
about impending shut-downs, and to automatically log them out if they do not
gracefully exit. But I will echo the caution... if there is a modal form
such as a MsgBox open, you will not be able to get control to log the user
out, so you have to be careful in your user interface design -- or take a
chance on "unanticipated results" due to some users still being logged in.

Larry Linson
Microsoft Office Access MVP
 
Back
Top