How can I limit user access to records in a table?

[Guest]

I have a database that contains salary information for each employee. I want
each Manager to be able to see/edit only records of their staff. How can I do
this?

 

[Joan Wild]

You can accomplish this using security, however it is a steep learning
curve, so study up on the topic and practice on a copy of your database.

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

In your case, you'll want to remove all permissions from the tables and use
RWOP (run with owner permissions) queries for all data interaction. You can
add a field to your table to indicate who owns the record.