Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    11

    Unanswered: Kick users out of my database

    Is there a way to eject or disconnect the current users of an Access 2000 database?

    There are times when we need to do work on the database and a user ignores the messages to get out, or a user leaves for the day and stays logged in to the database...

    I have found the MS Knowledge Base article that allows me to *see* who is in the database, but I can't find a way to remove them.

    Also, if there is a way, are there any issues I ned to be aware of when doing it?

    Thanks,

    Anthony Kroes
    Green Bay, WI
    Last edited by akroes; 11-16-04 at 13:02.

  2. #2
    Join Date
    Oct 2004
    Posts
    5
    I haven't done this before, but if you're using Access 2K, does that mean you're also using Win 2K & above server to host this database?

    In the Control Panel, go to Administrative Tools and double click on Computer Management. If you're using Active Directory, maybe you can ask your administrator to help with the shares. There is a Sessions folder and you can see who are using which files. You can log them out by right click.

    However, I don't know what would happen to the database. It may get corrupted. You should backup before doing anything else.

  3. #3
    Join Date
    May 2004
    Posts
    11
    Thanks - that's the way we do it now. I was looking for a way to do it without admin rights or playing with the server.

    I may have found a way from : http://www.rogersaccesslibrary.com/d...ogUsersOff.mdb

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by akroes
    Thanks - that's the way we do it now. I was looking for a way to do it without admin rights or playing with the server.

    I may have found a way from : http://www.rogersaccesslibrary.com/d...ogUsersOff.mdb

    Hi akroes,

    Also this company has a wealth of products, but this link takes you to the program they have that allows you Total Control over Access on a network. Anywhere from seeing who's logged on to sending warning messages you are about to shut down for maint. etc. Not free but if you need it they have it:

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

    Main site is :http://www.fmsinc.com/

    have a nice one,
    BUD

  5. #5
    Join Date
    May 2004
    Posts
    11

    Fms

    Good company - I've got their Access 'Analyzer' program. Didn't know they had an admin tool as well. Time to start saving up my pennies.

    Thanks,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •