Establishing Record Level Security in Access 2000

J

Jack

I have developed an employee projects inventory db...I
want to establish record level security so an employee
only access their individual projects records....

Is their a way in Access 2000 to only allow my users to
login to just their individual projects records?????
 
R

Rick Brandt

Jack said:
I have developed an employee projects inventory db...I
want to establish record level security so an employee
only access their individual projects records....

Is their a way in Access 2000 to only allow my users to
login to just their individual projects records?????
Click to expand...

You can deny access to the tables entirely and only allow data access
through RWOP queries and these queries can be set up to only include the
records you want them to see.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access - permission to change by record 1
Current User 1
User Level Security on Server 7
Restricting access to records 3
how to set up record-level security 2
Record Level Security 1
Record Level Security 1
RECORD LEVEL SECURITY 5

Top