Download Sample Access File: Set User Permission on Each Form ( V. 2010 and above)
This sample file demonstrates how to set up the user permission in MS Access. The user permission to add, edit, delete, or read only can be set on each form for each user as shown below. The Login form also is used to log in users in this sample file.
Highlight functions are included in this download file:
This form is initially loaded when program is opened. It prompts user to enter a Login ID and Password. If both Login ID and Password are correct then it will open the Main Form. For this example, the Main Form is a collection of buttons that will open each individual form. You can set it to open any form on this Login Form in your program.
#1 Select All Forms
Open the Set User Permission form then select user. If you want this user to have an access to all forms then you just select All Forms from the form list than check on the permission box. For example,
- If for Admin, select All Forms then check on Admin. All of permission boxes will be checked if the Admin permission is checked.
- If for user with all access right/permission, select All Forms then check on All. All of permission boxes will be checked if the All permission box is checked.
- If for user with Read Only permission, select All Forms then check only on Read.
#2 Select Individual Form
If you want the user to have an access to certain forms then you will need to select those forms from the list than check on the permission box that you want this user to have an access to each form. Some time you don’t want certain user to have same access on each form.
No Permission Set Yet
Even though the user is added into the user table but there is no permission setup on the Set User Permission form yet, the Access Denied message will pop-up after successfully logs in. The program will close after clicking on OK button. The user must be assigned the permission to at least one form or Main Form.
Download file contains:
5 tables, 8 Forms, and 2 Modules