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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Challenged by boss - 30 Jan 2007 17:33 GMT

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?

Reply to this Message

Joan Wild - 30 Jan 2007 18:57 GMT

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.

Signature

Joan Wild
Microsoft Access MVP

>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?

Reply to this Message