Kicking users out of my DB

[Damien McBain]

Is it possible to kick other users out of my Database so that I can open it
exclusively if I need to?

 

[Jeff Conrad]

Hi Damien,

I don't have any personal 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

 

[Damien McBain]

Hi Damien,

I don't have any personal 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

Cheers Jeff, I'll give that a lash

 

[Damien McBain]

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

Cheers Jeff, I'll give that a lash

Yep, the one called LogUsersOff2k is just what the doctor orders.

thanks again

 

[Jeff Conrad]

Excellent, glad to help.