Multi-user messaging

[Ritesh]

I have an access project that is used by many users on the same login at the same time. From time to time the system fails and the only way to resolve the problem is for all of the users to exit the system.

Is there anyway whereby i can send a message to all the users that will inform then to exit the system. Just a simple message box would do.

 

[John Crighton]

This is fairly easy to implement - just use a timer event on your main form
or a hidden form, which looks at a value in a table. This can be a boolean
value which if set to yes, gives the message.

You could also implement some kind of counting routine so that if they've
been told 3 times the database closes anyway using Access.Quit

John C.

I have an access project that is used by many users on the same login at

the same time. From time to time the system fails and the only way to
resolve the problem is for all of the users to exit the system.

Is there anyway whereby i can send a message to all the users that will

inform then to exit the system. Just a simple message box would do.

 

[Rick]

Go to this website.
http://www.fmsinc.com/products/Admin/index.asp
It has a program called Total Access Admin. You can find
users currently in the system, those who have been idle
for a while and it even allows you to logg users off the
database so you can do maintenance/backups. Great tool
for the administrator.

-----Original Message-----
I have an access project that is used by many users on

the same login at the same time. From time to time the
system fails and the only way to resolve the problem is
for all of the users to exit the system.

Is there anyway whereby i can send a message to all the

users that will inform then to exit the system. Just a
simple message box would do.