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:
Login Form:
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.
Select Form
#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.
User Permissions
1) Admin
Select All Forms from the form list and check Admin box. The user with Admin permission has all access right/permission to all forms. This admin will have full control and will be able to read, edit, add new record, and delete record.
2) AddNew
3) Edit
4) Delete
With Delete permission
Without Delete permission
5) Read
Select All Forms or any form from the list and check Read box. The user with Read permission has an access right/permission to only read or view the record on the form. The user cannot add new record, edit, or delete the record.
If the user with Read Only access/permission click on Add New Record button, it will be blank on add new record form. The user will not be able to add any new record.
If the user has no Read permission, the user will not be able to open that form. The message of Access Denied will pop up as shown below.
6) ButtonDisable
when the ButtonDisable button is checked the restricted button will be disabled as shown below. For example, if there is a button only for the admin to use on the public form, every user who is not an admin then should have this ButtonDisable box checked. So the user will not have an access to that button or to open the admin form.
It also works with the Navigation button on the Navigation Form. The Admin navigationbutton will be disabled if form is opened by a regular user with a ButtonDisable box checked.
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
