Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: List All Current Users

    When using MS Access security I can identify the current user
    "Hello '" & CurrentUser & "'" nice and easy all well and good but what I would
    like to know is there anyway to list all current users who are logged onto the system at any point in time.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes there is, from Access 2000 on, depending on the MSDAC/JET level you have
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I use this technique to see who's actually using the mdb/mde file or not (note the 2nd paragraph in the explanation):

    http://www.dbforums.com/showpost.php...6&postcount=19


    You can also see who's using an mde/mdb at any specific point in time using this method:

    http://www.dbforums.com/showpost.php...8&postcount=38
    or this...
    http://www.dbforums.com/showpost.php...7&postcount=42

    You can also see who's using an mde/mdb at any specific point in time using this method (if the backend tables are on SQL Server):

    http://www.dbforums.com/showpost.php...5&postcount=31
    Last edited by pkstormy; 10-13-08 at 19:29.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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