can a field within a table have security for editing?

K

Kathy

We have three users on one database. All three are editing certain columns
of information. Is it possible to lock a field within a table in an mdb so
that only certain individuals are allowed to edit the field?
 
R

Rick Brandt

Kathy said:
We have three users on one database. All three are editing certain
columns of information. Is it possible to lock a field within a
table in an mdb so that only certain individuals are allowed to edit
the field?
Click to expand...

You would have to implement Acces User-Level Security (an advanced topic).
Then you would be able to remove all permissions to the tables and give the
various users "Run-With-Owners-Permissions" queries instead. Then you can
simply not include that column for those you don't want to see it or embed
it in an expression for those you want to have read-only access to it.

You could do the same without implementing security, but then users would be
free to open the table directly or open a query intended for other users.
 
Top