<div>
add a field to your table UserRole and assign values to each users, like Admin, User
</div>


add a field to your table UserRole and assign values to each users, like Admin, User

<div>
add a field ( UserRole ) to your table and assign values to each users, like Admin, User
</div>


add a field ( UserRole ) to your table and assign values to each users, like Admin, User

<div>
Thanks Capricorn1, having done so, how do I change form operations based on tblLogin.[UserRole]?
</div>


Thanks Capricorn1, having done so, how do I change form operations based on tblLogin.[UserRole]?

<div>
<div class="content wysiwyg-content">
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. &nbsp;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. &nbsp;What other steps should I take after creating the simple login page to allow this?<br />
<br />
Thank you,<br />
Bevo
</div>
</div>


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

Access Login Form, how to control what users can edit

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.