Results 1 to 12 of 12
  1. #1
    cec is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Apr 2012
    Posts
    42

    Is there a way/code to see who is in the database


    I have been researching to see if there is a code, etc. way to find out who is in the database. I'm having problems trying to do modifications and all the User's are not exiting. I created/built the database but do not have the admin rights, so I'm trying to figure out if I could set up a User login and password and create a code, etc. and be able to see who is still in the database by running the code and it will give a list of the User login???

    can someone please help me with this!!!!

    thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I do this with split database. Each user has copy of frontend on their local computer. When they open db code pulls username from the network, matches to record in Users table, and updates a record with computer name. When they close the frontend the computer name value is removed from the table (I have code that disables the X close and a custom button to close db).

    Users
    UserNetworkID
    UserInitials
    ComputerName

    Review: https://www.accessforums.net/access/...gin-23585.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You may also wish to add some form of "kick em off" code: http://www.accessmvp.com/JConrad/acc...e/kickoff.html

  4. #4
    cec is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Apr 2012
    Posts
    42
    Thanks for both it helped. I have a question now that I have my text box working pulling the right person (in the main menu when open) how do I do the query. I have tried and nothing seems to work

    thanks

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    There is a field in the query that has user info, such as initials or name? What value is in the textbox?

    Show the sql statement you attempted.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    cec is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Apr 2012
    Posts
    42
    i'm not sure that I understand. I'm farely new at this too. Do I make the query in the split db or the one everyone use's?

    SELECT tblEmployee.UserName, tblEmployee.EmpID, tblEmployee.UserInitials, tblEmployee.ComputerName
    FROM tblEmployee
    GROUP BY tblEmployee.UserName, tblEmployee.EmpID, tblEmployee.UserInitials, tblEmployee.ComputerName
    HAVING (((tblEmployee.EmpID)=[Forms]![Switchboard]![Text26]));

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Build queries in the frontend.

    That query should work. Why are you querying tblEmployee? Why is it an aggregate (GROUP BY) query?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    cec is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Apr 2012
    Posts
    42
    I still have not been able to master this. I have someone else in it and when I run this SQL:SELECT [Forms]![Switchboard]![Text26] AS EmpID

    I am only getting my information and I know someone else is in it.

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Queries SELECT fields of a table (or another query). Selecting a value from a textbox does nothing unless that value is the name of a field in the target table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    cec is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Apr 2012
    Posts
    42
    ok that makes since. Could I still do this even if my db isn't split??

  11. #11
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72
    I'm not sure (my guess is you cannot) but there are lots of advantages of splitting your database. Improved performance when multiple people are using it is one.

    see here: http://www.techrepublic.com/blog/10t...-database/1119

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    My post2 describes how I track who is using the db.

    This thread discusses how I manage a split db: http://forums.aspfree.com/microsoft-...ue-323364.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running a code in an inherited Database
    By jlgray0127 in forum Forms
    Replies: 12
    Last Post: 03-14-2012, 02:58 PM
  2. Can somebody review the code in attached database?
    By A Abbas in forum Programming
    Replies: 4
    Last Post: 01-27-2012, 04:57 AM
  3. Copy Database Code Error
    By Tomfernandez1 in forum Programming
    Replies: 5
    Last Post: 05-03-2011, 12:21 PM
  4. Code needed when Database is Opened
    By Access_Headaches in forum Access
    Replies: 7
    Last Post: 08-13-2010, 01:03 PM
  5. Replies: 3
    Last Post: 04-05-2006, 04:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums