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

[itllfly]

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.

 

[Rick Brandt]

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.

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.