Terminate database with users logged on

[karen d]

I have a database running and can not attain exclusive
possession, but cannot find who is logged on (we have some
old users which are being used as aliases). Does anyone
know how to close a database or otherwise "kick off" all
users from one?

 

[Jeff Conrad]

Hi Karen,

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

Hope that helps,