Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello again

    How can I find out who the users are in an Access Database? I seem to rememer an old post containing instruction on how to see who currently has an access database open, but search hasn't let me find it, not that I'm an expert with the search faciloity

    I have the unusual situation of an unsecure database (one that does not have Access security implemented, anyone can open it if they have the network access) that is related to two others, we are currently finding out that if the 'master' database is open one of the other systems can not be updated with information, as we can't remove the link it would be nice if we could easily find out who was in the 'master' database.

    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000 (works for Access 2002 and 2003 too, I don't know about Access 2007).

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='HansV' post='786683' date='29-Jul-2009 07:37']Try How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000 (works for Access 2002 and 2003 too, I don't know about Access 2007).[/quote]
    It should work for Access 2007 as long as the database format is .MDB - but I wouldn't expect it to work with the .ACCDB format, although I've not tried it.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Thanks, Wendell!

  5. #5
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans, works a treat

Posting Permissions

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