Establishing Record Level Security in Access 2000

  • Thread starter Thread starter Jack
  • Start date Start date
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?????
 
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.
 
Back
Top