Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have an access file out there for common use and don't know who has it open and i'd like to either find out in order to ask whomever to close it or just close it automatically. is there a way to do this? i didn't implement any kind of roles and permissions stuff.

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See 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, and for .mdb databases in Access 2007).

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks - unfortunately, both of the db's I want to poll are opened by someone so I can't add the module. if i try it in a separate db, targeting the opened db, I get 'Cannot open <db> it is opened exclusively by another user.'

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    This only happens if someone has the database open exclusively - there is an option for this when opening a database, and it happens automatically if the user opens a database object in design view. It doesn't happen if people are just using the database.


  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    guess someone is messing with my db. how do i kick them out?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    There are ways to logout users automatically, but to build this into the database you'll need to have exclusive access to the database! So if you can't reach the users, you'll have to wait until they close the database.

    See for example Auto Logout Users for DB Maintenance.


  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    alrighty. i really just want to delete it completely as i have moved the production version to a local machine. the other code for finding who's in it now works, but it gives me a machine name, not something more useful like network login id. i know how to get this from a access db that is opened by x user in the db itself, but not how to tickle a db remotely to get that info. that would be great to have...

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't know how to retrieve the Windows login names of other users, only that of the current user.

    You could store the Windows login name of each user in a table when they open the database, and remove it when they close the database. See View login ID's of users currently using the DB. But this is tricky: if Access crashes, the username won't be removed from the table.


Posting Permissions

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