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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

itllfly - 11 Jun 2006 05:08 GMT

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.

Reply to this Message

Rick Brandt - 11 Jun 2006 13:06 GMT

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message