Access Security at the Back-End

[robboll]

Using the WorkGroup Administrator ther are Admin groups, Full
Permissions, New Data permissions, update permissions, etc. Is there
a way -- from the back end -- to change the permissions on just one or
two columns?

Say you have a group who you want to have edit permissions to a table
-- but after a period you want to lock certain columns of that table.
Can this be done using MS Access 2003?

Appreicate any suggestions.

RBolling

 

[Scott McDaniel]

Using the WorkGroup Administrator ther are Admin groups, Full
Permissions, New Data permissions, update permissions, etc. Is there
a way -- from the back end -- to change the permissions on just one or
two columns?

Say you have a group who you want to have edit permissions to a table
-- but after a period you want to lock certain columns of that table.
Can this be done using MS Access 2003?

Appreicate any suggestions.

Access does not allow column-level locking, and users really shouldn't have direct access to your tables. Give them
access through a form, and control what columns are updated using the form's events (i.e. BeforeUPdate, BeforeInsert,
etc).

RBolling

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com