Kick a user out of a database

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

Hi
I am running Access2000
I have a multi user environment db.
Is there a way to kick someone out of a db? (if they forget to close it
and left)
Regards
Kay
 
Hi Kay,

Yes, there is a way to do this. Please see the following article:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

This is covered in the section that is titled "Close inactive sessions".
This is an important technique to help prevent database corruption. I once
helped a person with their multiuser application which was corrupted every
morning when they came to work. It turned out that one employee was leaving
their computer turned on, with the database open. This particular company had
a policy in effect that automatically shut off all computers at 10:00 PM each
night.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Shared vs Split Database 6
How to stop a DB without code to make changes? 1
Kick users out of Back End 1
Kick off user from access 2003 db 5
Restricting Access To Database 2
How do I kick users out of an XP Access database 3
kick users off the be 2
Kicking people out of a network database 8

Back
Top