Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
Bevos
Asked:
Bevos
  • 3
1 Solution
 
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
 
Rey Obrero (Capricorn1)Commented:
you can use something like this

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

0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now