Kicking User Out

[ChuckL]

I have a database available to multiple simultaneous users
(30-40). Occasionally, I am going to need to update
tables in the database. The tables are locked when users
are accessing the application, therefore, I am unable to
delete and save new tables. Is there a way for me to kick
users out of the database so that I can make the proper
updates?

Thanks alot for your help!

 

[Br1an_g]

I have an ldb viewer that i use to find out who is in the
database, then i 'Net Send' a prompt to each user to close
the database.(or create a batch if there are lots)

I would also like to know how to Kick them out, as it
would save some time

Brian

 

[Joan Wild]

There are a number of samples:
http://www.datastrat.com/Download2.html - KickEmOff2K
http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb

 

[BarbaraC]

Just curious about your ldb viewer. Is it available
online or did you create it? Would like to use the same
concept!

 

[Br1an_g]

I am using Access 97,

check this page in the knowledge base:

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;176670

Has links to Jetutils.exe for access 97 ldb viewer, and a
link to retrieveing the same info in access 2000

HTH

Brian