How to Change the Password Form in Access
In Microsoft Access, you can create any type of password you want. After a password is created, you can change the password form by resetting the password. You must have the current password to create a new one. This applies to the main database password, individual user passwords and passwords created for individual sections of the Access database. No matter what level of password you want to change, you can change the password form in Access.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Access. Do not open your database first.
-
2
Go to the "File" menu and choose "Open."
-
-
3
Select your database and press the arrow on the "Open" button.
-
4
Choose "Open Exclusive."
-
5
Go to "Tools" and select "Security."
-
6
Change the form of the main database password by selecting "Set Database Password."
To change passwords for users, skip to Step 8.
-
7
Enter your password. In the Verify box, enter your password again. Press "OK" to save the password.
If you already have a password, enter the old password first.
-
8
Go to "Tools" and select "Security."
-
9
Choose "User and Group Accounts."
-
10
Select the user name and press "Change Logon Password."
-
11
Enter the old password and the new password twice.
-
1
Tips & Warnings
Use a strong password with a combination of letters and numbers to keep the database secure.
If you have a special form for a user to enter his or her password, you can alter the form itself by going to "Forms" in the main database window. Select your form and select "Design View." Edit the form to fit your needs. Right-click your password field and choose "Properties" to edit the field itself.
Never share Access passwords. This can result in data loss through unauthorized access to your database.
