Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Security on a form

Status
Not open for further replies.

goslincm

MIS
May 23, 2006
292
US
Good morning. I implemented user-level security on an Access database but am new to this and still have a question. How do I allow my User Group to open my employee form in add mode only, while allowing my Personnel Group to open my employee form in edit mode?

 
You could set the permissions on the table or query on which that form is based, giving Insert but not update or delete to the user group, then update and delete, but not insert, to the personell group.
--Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top