PDA

View Full Version : Field Level Permissions



ganesh3084
06-15-2011, 01:40 AM
Im doing a project in access which i have tables and forms. I have applied user secuity in my project.In that, some users have All permissions to insert,update and delete the data and some user has only insert permissions and doesnt have any other permissions.

I have 10 different fields in my form.

My Requirement is for non editable users, they cant able to edit the record once they inserted. But i need to allow only two columns to edit say an example, I have a dropdown field named Status with two options Open and Close and a Text Box Named Closed Date.If they Select Open from the dropdown, then i need to give edit permissions for Status and Closed Date fields only.. After inserting the record and again once they select the Close Option in the dropdown field, then the entire record should goes to Read-Only. Is it possible to do like this??

Please Suggest me..

Thanks