How do you boot connected users from your database ?

[u473]

.... Or, How do you identify connected users ?
Help appreciated.

Celeste Edwards,

[Pachydermitis]

There is a list of connected users in the LDB file that access makes
when it opens. Booting them out is another story. I am guessing that
the db in question is a backend? Most people set timers that close the
frontend database after a certain amount of inactivity, or set a flag
in a table in the backend that the front end checks periodically. I am
sure there is a much more elegant way to do it, but I don't know it.
HTH
Pachydermitis

[pietlinden]

How do you boot them out? KickemOut is on Arvin's site. Datastrat.com

Connected users... I think there's code for that on mvps.org/access
Look for LDB, I think. IIRC, its LDB File Viewer.

[Hank]

I've been doing this for years, whenever I need to change a table
or something in the middle of the day. I have the timer running in
the Main Menu and it checks for a shutdown flag once per minute. If it
sees the flag, it closes all forms except the Main Menu and puts up a
big banner that explains the situation.
The reason I do not shut them completely down is because a person
coming back to his/her desk would not know what happened if it was
totally shut down and would simply start it up again.
The banner explains everything and asks them to wait. When I'm
finished with my task, I reset the shutdown flag and the users can
resume.
I have never had any issue with losing the current entry when
shutting down forms this abruptly.
If you need more help, let me know.
Hank Reed