NETWORK USERS

[Guest]

I have a database that resides on the network. Around 12:15p each day all users are suppose to be off. Some forget to exit and you have to go around and find out who they are.

Is there a simple way to automate throwing all users off the database?

Thanks in advance

 

[Douglas J. Steele]

See whether the KickEmOff sample Arvin Meyer has at
http://www.datastrat.com/Download2.html helps.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a database that resides on the network. Around 12:15p each day all

users are suppose to be off. Some forget to exit and you have to go around
and find out who they are.

 

[Guest]

I've loaded the form, table and module into my database.

It works if I click on the form let's say for me but on a network the other users are still on. This is something I'm missing?

 

[Arvin Meyer]

The form and code (front-end) has to be on each machine. The table on the
network drive where the rest of the data (tables) is, with a link to each
front-end. The form checks the table periodically for the value to kickem.
If it finds it, off they go. I usually open the form hidden, from either the
autoexec macro or a startup form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I've loaded the form, table and module into my database.

It works if I click on the form let's say for me but on a network the

other users are still on. This is something I'm missing?