How do I kick people out of a database?

[Jason Cramer]

How do I kick people out of a database? I have about 20 users in a database
that I maintain and it crashes occasionally so I need to do a compact/repair.
Unfortunatlely, it usually crashes when they are all at lunch so it takes
forever to get them all out of the application or I'm forced to shut down the
computer. Is there any way to do this on the back-end?

 

[Troy]

Well, if it's Access 2000 or higher, there is an application by FMS, Inc
that has this capability once you've implemented the code (included in
sample apps).

Total Access Admin:
http://www.fmsinc.com/products/Admin/index.asp

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


How do I kick people out of a database? I have about 20 users in a database
that I maintain and it crashes occasionally so I need to do a
compact/repair.
Unfortunatlely, it usually crashes when they are all at lunch so it takes
forever to get them all out of the application or I'm forced to shut down
the
computer. Is there any way to do this on the back-end?

 

[Jeff Conrad]

in message

How do I kick people out of a database?

Go over to their desk and give them a good wedgie.

Then empty your desk and start looking for another job.
Kidding....

I have about 20 users in a database
that I maintain and it crashes occasionally so I need to do a compact/repair.

I would begin to figure out *why* it is crashing ASAP!
This is not good.

Review the following links for great information:

http://members.iinet.net.au/~allenbrowne/ser-25.html

http://www.granite.ab.ca/access/corruptmdbs.htm

Unfortunatlely, it usually crashes when they are all at lunch so it takes
forever to get them all out of the application or I'm forced to shut down the
computer. Is there any way to do this on the back-end?

Sure, 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

http://propertychampion.com/Developer_Tools/Addins/Addins.html
Look for "Force User Out"

"Who's Logged In" Sample Database:
http://www.rogersaccesslibrary.com/misc/Whoson.97

Hope that helps,

 

[Immanuel Sibero]

I think the wedgie route is easier

in message


Go over to their desk and give them a good wedgie.

Then empty your desk and start looking for another job.
Kidding....

compact/repair.

I would begin to figure out *why* it is crashing ASAP!
This is not good.

Review the following links for great information:

http://members.iinet.net.au/~allenbrowne/ser-25.html

http://www.granite.ab.ca/access/corruptmdbs.htm


Sure, 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

http://propertychampion.com/Developer_Tools/Addins/Addins.html
Look for "Force User Out"

"Who's Logged In" Sample Database:
http://www.rogersaccesslibrary.com/misc/Whoson.97

Hope that helps,