Filtering by log in password (Access 97)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote