Log all users out of database

Guest · Mar 12, 2004

Hiya

I was wondering if anyone knows a good way for me to be able to automatically kick all current users out of a database

I need to do this because I have to update the database every morning and people keep leaving their damned PCs on overnight with the database open

I have to use a direct update (linked tables etc are not appropriate)

The only thoughts I have are some kind of form timer events on the main switchboard (which will always be open in the background)... Could someone lead me in the bets direction - if I could kick everyone out by clicking a button it would be ideal

Thanks loads

Basil

Phil Hunt · Mar 12, 2004

You could have a timer on one of the form that close down the app at night.
Then you just have to come in early to do your thing.

Basil said:
Hiya,

I was wondering if anyone knows a good way for me to be able to

automatically kick all current users out of a database?

I need to do this because I have to update the database every morning and

people keep leaving their damned PCs on overnight with the database open.

I have to use a direct update (linked tables etc are not appropriate).

The only thoughts I have are some kind of form timer events on the main

switchboard (which will always be open in the background)... Could someone
lead me in the bets direction - if I could kick everyone out by clicking a
button it would be ideal!

Roger Carlson · Mar 12, 2004

I'm not sure I follow the bit about linked tables. However, on my website
(see sig below) are two small sample databases called "LogUsersOff" and
"LogUsersOffNonUse" which might work for you.
--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org