Following a good reception in the open forums, I'm posting this in here for you to download and use at your leisure!

Have you ever wished you could quickly get all your users out of the db because you need to do something design-wise in the back-end of the database?

This mini-app could be the answer...

This database (and there's 97 & 2K versions attached) will allow you to create a message which will be displayed to every active user on your database. This could be a "Happy Easter" message... it could be a "Please log out at 3 pm" message... the options are limitless!

All you need to do is:

Drop the table tblSystemMessages into the BE, and link to the FE.
Get the form frmSystemMessageCheck to open HIDDEN when the db opens for the first time. This checks the contents of tblSystemMessages (using DAO, so ensure you check the necessary reference if needed) every 300,000 milliseconds (or 10 minutes) - this can be changed if you like! If there are any new messages, it displays them one by one in a message box.

To create a new message, open the form frmEditSystemMessages and drop your message in there.

If you have any queries or comments, please PM me.

Ad.

Edited by: ghubbell on 04.26.04.