Disconnecting users from a split db

[M Smith]

I have an Access 2000 application that uses a split database and has
multiple users connected to it. I want to be able to give one user the
ability to knock all users off the system. In other words, disconnect all
users from the backend. How would I go about coding this? Users connect
using DAO 3.6. I thought of trying a For Each with the Connection object
but didn't get anywhere with that. Any help would be appreciated.



Thanks

 

[Douglas J. Steele]

There's code in http://support.microsoft.com/?id=128814 that shows how to
disconnect a user due to inactivity. You could modify that code to check for
a flag in a given table, and kick them out if the flag is set.

 

[M Smith]

Is there a way to tell how many users are connected to the back end?