HI,

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

Thanx!

Myron wrote:
> Even if they are currently using the database?
>
>> -----Original Message-----
>> If you are the Admin when you open the database Open
>> it "Exclusive" that disconnects the Users
>>> -----Original Message-----
>>> HI,
>>>
>>> I was wondering if there is a way to Bump all users off
>>> an Access2000 Database?
>>>
>>> Thanx!
>>> .
>>>
>> .

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.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

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...b;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

--
Joan Wild
Microsoft Access MVP

>-----Original Message-----
>HI,
>
> I was wondering if there is a way to Bump all users
off
>an Access2000 Database?
>
>Thanx!
>.
>