Booting off Users of database

[Bob]

I have an extensive database, that dozens of users log
into using user security logins. I can view who is
currently logged into the database, by viewing the LDB
file. But is it possible to boot someone off when i want
to perform a system backup?... the backend (datafiles) are
locked periodically as long as a logged in user is
connected to any of them.


Thanks in advance for any info.

 

[Jeff Conrad]

Hi Bob,

I don't have any experience with this task, but see if these links help.
Watch out for any possible line wrapping on these links!

http://www.datastrat.com/Download2.html
Look for KickEmOff2K sample database.

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOff2k.mdb'

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOffNonUse2k.mdb'

http://support.microsoft.com/?id=198755

http://support.microsoft.com/?id=285822

http://www.candace-tripp.com/_pages/access_downloads.asp
Look for Detect and Logoff Idle Users

Hope that helps,
Jeff Conrad
Access Junkie
Bend, Oregon

 

[Dan Sweetwood]

If your OS is 2000+ you can on the server go to Programs/Administrative Tools/Computer Management/ then look under system tools for the Shared Folders. Open that folder and then open the Sessions folder. You will see a listing of all users connected to any shared folders/files on the server. Delete the sessions that are connected to the database and they will be off. I would before hand send a message to all network users warning them of the disconnect. That can be done in the Computer Management console by clicking on the Action Menu then All Tasks/Send Console Message. You can also send a console message to everyone from the Command (Run/CMD) Prompt using "net send *(meaning all computers on the network) then just type a message such as "The database will be temporarily down for backup. Thank you. " Hit enter and it will broadcast to all desktops. Good luck.

 

[Tony Toews]

If your OS is 2000+ you can on the server go to Programs/Administrative Tools/Computer Management/ then look under system tools for the Shared Folders. Open that folder and then open the Sessions folder. You will see a listing of all users connected to any shared folders/files on the server. Delete the sessions that are connected to the database and they will be off.

1) This has a risk of corrupting the MDB

2) The users can go right back in again despite any messages you might
send them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

There is a simple way to do this. Create a table in your
database with a yes/no field.

In a code module or form, build a timer event that
executes every minute or so. This code will look at the
yes/no field, if it is marked yes, then it will put up a
message box warning the users that the app will close in x
number of minutes for database maintenance. Then when
that time expires, force the app to quit (docmd.quit)

Now when you want to throw everyone out, just check this
box.

PJ