Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

set column to uneditable

Discussion in 'Information Technology' started by Ryan, Jul 28, 2006.

  1. Ryan

    Ryan
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Settlement Leads To Peaceful Transition At Sikh Temple Breaking News Sep 10, 2016
    Sikhi Langar-Aid - Sikhs Have Set Up A 'Langar' In The ISIS Territory of Syria To Feed Refugees Sikh Sikhi Sikhism Oct 31, 2015
    A set back or a step forward Blogs Oct 17, 2015
    USA Sikh Cartoonist Sets Out To Fight Racial Bias Breaking News Mar 9, 2015
    India Who says we have skeletons only in our closets? Breaking News Aug 22, 2014

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    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.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Ryan" <Ryan@discussions.microsoft.com> wrote in message
    news:3A26CC98-FB12-49E3-964E-587A7E33E82F@microsoft.com...
    >
    > 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
     

Share This Page