Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filtering by log in password (Access 97)

    I have a database that is secured by access using the user security. I now need to secure it more. Currently, a user can log in and see all the records and I need to filter the records by the user's log in so they can see only the employees who report to them. How can I do this?

    Thanks,
    Deborah

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Filtering by log in password (Access 97)

    It sounds like you need a field in the record or a linking record that tells you who a person reports to. If you have that, you can use the CurrentUser() function as a criteria in a query to restrict the records displayed. Of course the linking field must contain a text string that matches their supervisor's Access UserID.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filtering by log in password (Access 97)

    Log in as someone with full permissions. Create a query that filters the records by login name. Set the Run Permissions property of the query to Owner's. Grant the standard users permission to open this query, but take away their permissions on the underlying table. They won't be able to open and view the table, but they will be able to open the query, and when they do so the query will use your (the owner's) permissions.

    See section 10 in Access Security FAQ

Posting Permissions

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