Access Security at the Back-End

  • Thread starter Thread starter robboll
  • Start date Start date
R

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
 
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.
Click to expand...

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
Click to expand...

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