Send Message Box to Users Logged in

[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!

 

[Rick Brandt]

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!

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.

 

[Larry Linson]

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

 

[Daniel Pineault]

Take a look at

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=328

It can force all the user out so you can do maintenance... and will show a
popup that you can customize to suit your needs.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.