Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Users who are logged on. (AXP / Win XP)

    Is there a way that I can capture who is logged onto the database? I have some code that captures the NT User name. I need to be able to post a page that shows who is running the database.

    Thanks,
    Mark

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Users who are logged on. (AXP / Win XP)

    CurrentUser() shows user currently logged on to the database. In a non-secured database the result is always "Admin".
    also search the lounge for current user <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    HTH

    Peter

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Users who are logged on. (AXP / Win XP)

    Thanks!
    The DB is not secured but I do grab their computer name on startup. I want to display who is currently logged in by name. I guess I could write their name to a temp holding spot in a table, then just erase that entry when they log off. Later on I will use SQL server and I will need to get it figured out there as well.

    Thanks again,
    Mark

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Users who are logged on. (AXP / Win XP)

    SQL Server does NOT let everyone log in as Admin. Otherwise, some DBA is going to be looking for a new job when their totally unsecured SQL Server database gets trashed by someone who never should have been in it. Where exactly were you planning to display who was logged in? And do you mean you want to show a list of those who are logged in, meaning you would have to store *all* their logins and keep them current?
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Users who are logged on. (AXP / Win XP)

    Hi Charlotte,
    I want to show the names of those that are logged in. I do not have any interest in storing their passwords and I plan on using NT for security. The users are in different geographical locations and I want all users to be able to see who is active on the system. They do not have "Admin" access to the database in the sense that they cannot open the tables for editing or design.

    Thanks,
    Mark

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Users who are logged on. (AXP / Win XP)

    Hey Charlotte,
    Tell me, does the .ldb show who is currently logged on to the database. Or is this file just for locking pages/records?
    Cheers,
    Pat

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Users who are logged on. (AXP / Win XP)

    Sort of. I don't usually bother with trying to read ldb files, and I can't recall exactly what's stored in them, although this has been discussed a number of times in this forum, so a Lounge Search should turn up the answers. The catch might be knowing which ldb file to look at and having the necessary permissions to read it. For a shared FE on a server there should be one on the server that has a record for each currently logged in session, but unless you use Access security I believe you would get a bunch of "ADMIN on ... ", plus the machine name, which isn't too enlightening. If only the BE is on the server, I'm not sure what you would get. I've noticed that the BE lock file is only there when a connection is active, that is, when a table is open. If no tables are currently open, the lock file disappears.

    There are various tools for reading ldb files, and some of them have been discussed here too, but I don't know if they would give Mark the means to put the information into a format he could display on a form, even if Access security were being used.
    Charlotte

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Users who are logged on. (AXP / Win XP)

    You mean you're planning to use NT authentication for SQL Server access? That actually works fairly well from what I've seen, although it is not the safest way to secure your SQL Server back end.

    In Access, unless you use security or are very careful in coding, the Admin user can do pretty much anything they want, and everyone logs in as the Admin user. You don't actually have to use passwords in Access security *except* on the Admin user. It is perfectly happy to let everyone else log in with just their login name and an empty password.
    Charlotte

Posting Permissions

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