In Access, can you restrict users to view/edit specific records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to retrict users to only view/edit a specific subset of
records within a database. Example: Saleman Bob can only see orders
associated with his customers - he cannot see Saleman Terry's orders and
Terry cannot see his.
 
itllfly said:
Is it possible to retrict users to only view/edit a specific subset of
records within a database. Example: Saleman Bob can only see orders
associated with his customers - he cannot see Saleman Terry's orders
and Terry cannot see his.
Click to expand...

Yes. You would implement User Level Security (big topic itself), restrict
access to the tables, and use RWOP (run-with-owner's-permission) queries for all
data access. Those queries would then have criteria that limited the rows
returned to those appropriate for the current user.
 
Back
Top