Disconnecting Users

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I am using an Access 2002 Database that is located on a
server where everyone has access to to the .mdb file
directly. Sometimes people don't rememeber to close the
database before leaving thier desks and locking thier
computers and I was wondering if there was a way to
disconnect these users without having to shut off thier
computer. Everyone using the database has Admin access.
Any ideas? Thanks!!

Michael
 
One simple way that I have used is to create a hidden form that opens
automatically when the database is opened. Then use the On Timer event to
check the time. For instance, if you want the database to shut down by a
specific time each night. Then initiate an exit database event.

I have also used this method to evaluate a checkbox field in a table. When
I check the box... it forces a shutdown the next time the On Timer event
runs. That way I can force people out as the need arises.

Steve
 
Back
Top