We have a multi user database ( I didn't design it only manage the users). 20 concurrent users doing data entry. Occaisionally we need to boot everyone off but some people don't exit properly and then we have to go PC to PC to find the one still connected. Is there a way to disconnect users from the database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Force users off Access 2000 Database 1
- Thread starter dtay1132
- Start date
-
1
- #2
Have a hidden form with a timer control that is always running. Every n seconds the timer event will run a procedure to see if an exit condition exists. If so, run application.quit (maybe after providing a countdown warning).
I usually use a file in a folder to signal that all apps should quit. Call the file "quit_app.txt". When your hidden form sees this it will intiate shutdown. You can delete the file when you are ready to have users log back on.
Mike Pastore
Hats off to (Roy) Harper
I usually use a file in a folder to signal that all apps should quit. Call the file "quit_app.txt". When your hidden form sees this it will intiate shutdown. You can delete the file when you are ready to have users log back on.
Mike Pastore
Hats off to (Roy) Harper
- Status
Similar threads
- Locked
- Question