set column to uneditable

[Guest]

Hi all,

We are using access on a large network. We have given users access to the
database in question and were wondering whether there is a way to make some
columns of the database viewable but not editable and how we could do this?

Thank you in advance for your help

Ryan

 

[Allen Browne]

Access does not support configuring some fields with different permissions
than others in the same table.

If all your edits happen in forms, you could just set the Locked property of
the control on the form.

If you want to fudge it differently for different users, see:
Field-level permissions
at:
http://allenbrowne.com/ser-55.html

If you have serious security needs, you could break the sensitive fields out
into a separate table (one-to-one relation to the original one), which lets
you set different permissions.