NETWORK USERS

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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Sue" wrote in message
...
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

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?

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Sue" wrote in message
...
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

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

"Sue" wrote in message
...
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?

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Sue" wrote in message
...
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