Is it possible to lock individual records from being modified by certain users?
I have a contact management database which I would like all users to be able to view all records but only selected users can edit certain records. So if a user wants to add or edit an address related to him/her they could do it. But if they wanted to edit a record which had the "Contact type" defined as "Partner," they would not be able to edit that record. Only the CFO or his assistant would be allowed to edit the record.
Would I need to create an Edit button that would prompt for a password? Could I have users login when the database opens and depending on the user, the rights would allow edits to the Partner records?
I hope this is clear...Thanks!
I have a contact management database which I would like all users to be able to view all records but only selected users can edit certain records. So if a user wants to add or edit an address related to him/her they could do it. But if they wanted to edit a record which had the "Contact type" defined as "Partner," they would not be able to edit that record. Only the CFO or his assistant would be allowed to edit the record.
Would I need to create an Edit button that would prompt for a password? Could I have users login when the database opens and depending on the user, the rights would allow edits to the Partner records?
I hope this is clear...Thanks!
