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?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grey background behind text document 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Incorporating the User Profile location into a document template path 1
Before starting Access 0
Word 2016 opening sooo slow 0
How do I turn off annotating with ink in Excel 2016 2
How can the font and size of (all) citation numbers be altered? 1

Top