Access Login Form, how to control what users can edit

Hello, I have made a login form for a new access database which will contain a simple look up based on username selection from combo box checking to see if the password the user has entered matches that record in a table.  I want to be able to assign users to either be an administrator (i.e. can edit forms, view nav bar etc...) and a user who can only use the switchboard, form controls, and enter data.  What other steps should I take after creating the simple login page to allow this?

Thank you,
Bevo
BevosAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you can use something like this

http://www.tek-tips.com/faqs.cfm?fid=1172

0
 
Rey Obrero (Capricorn1)Commented:
add a field to your table UserRole and assign values to each users, like Admin, User
0
 
Rey Obrero (Capricorn1)Commented:
add a field ( UserRole ) to your table and assign values to each users, like Admin, User
0
 
BevosAuthor Commented:
Thanks Capricorn1, having done so, how do I change form operations based on tblLogin.[UserRole]?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.