Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Question Unanswered: Can you see which users are logged into a DBase?

    I designed a database in MS Access 2000 that has user-level security passwords. I would like to be able to see which users are in the database at any given time (if I need to kick them out to do updates).

    Is this possible? If so, please explain in detailed steps since I am not very experienced.

    Thanks in advance!

  2. #2
    Join Date
    Apr 2003
    Location
    Homer, Alaska
    Posts
    15
    Exlpaining it would be a little hard by itself so I'm attaching a sample database....
    basically I set up a table that keeps track of users & whether they're logged in or not.
    Next I created a form that sets their status. (This form is hidden so the process is transparent to the user)
    Next I went to "Tools -> Startup" & set that form to be the starting form for the database
    I also created a form where you can view all of the users & their status.
    When the database is closed their status gets reset.

    To use this in your own db just copy the 2 forms the 1 table & set your db to start with the "frmStartup" form

    hope this helps.....
    Attached Files Attached Files

  3. #3
    Join Date
    Oct 2003
    Posts
    5
    [Thank you very much for your help and quick response!!! I will try this.

  4. #4
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    any chance on having a copy in A97version?

    Thanks in advance

  5. #5
    Join Date
    Apr 2003
    Location
    Homer, Alaska
    Posts
    15
    Here ya go...
    Attached Files Attached Files

  6. #6
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    thanks dude!!! :-)

Posting Permissions

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