How do I get Users off the Database.

M

Myron

HI,

I was wondering if there is a way to Bump all users off
an Access2000 Database?

Thanx!
 
J

Joseph Meehan

Myron said:
Even if they are currently using the database?

I hope Buck is right, but I don't think so, at least not with Access 97.

I just phone them. I have an LDB viewer and a list of all the names and
numbers.

It seems to me I have seen some schemes to dump uses using code.
 
J

Joan Wild

Buck's method would only work if no one was currently in the database i.e.
prevent anyone else opening it.

Joseph's method certainly works, although can be time consuming. The
ldbviewer he mentioned is available for download. Since you are using 2000,
see
HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;198755

To kick users out, there is a sample at
http://www.datastrat.com/Download2.html
called KickEmOff2K

Also Total Access Admin from FMS will give you this
http://www.fmsinc.com/products/Admin/index.asp
 
Top