MS Access Password Set-Up,
Deletion, and Change
For (2007-2013) Databases that are private and a password, you can set-up individual passwords for each database you. Follow these simple and easy to follow this MS Access Password Set-Up, Deletion, and Change work instruction
Setting up an MS Access Password
- Step 1: Open the Database that you want a password applied to
- Step 2: Next Click ‘File’ at the top left corner
- Step 3: Click on Encrypt with Password
- Step 4: Enter your password and then verify it ….. write it down somewhere safe. Do Not Forget it because if you do there is no way to retrieve it !!! Click OK to save it.
- Step 5: Another POP-UP Box will appear with an alert stating “Encrypting with a block cipher is incompatible with row level locking. Row level locking will be ignored.”
- This message advises you that the database’s current default is set to prevent two (2) or more users from making changes to the same record field at the same time. Therefore, if there are multiple users that are in the same database at the same time, they are locked out of a row that is currently in use by another user. In other words, data cannot be changed in a table row at the same time. Only one user has that access, thus avoiding data inconsistencies.
- Simply click OK to accept this pop-up message. Your password and security will now be set.
Now you are DONE setting up your password!
Every time you try to open your database, a pop-up will appear asking you to enter your password.
How to Remove your MS Access Password
- Step 3: Type in the password you have been using. This will unset the database password after you enter OK.
Done ! Now you will no longer require a password to open the database !
Changing an MS Access Password
- First you will need to remove the password, then set-up a new password.
- See How to Remove an MS Access Database Password (Steps 1-3 above):
- Click on ‘File’ at the top left corner
- Click on Decrypt Database
- Type in the password you have been using.
- This will unset the database password after you enter OK.
- See Setting up an MS Access Database Password (Steps 2-5 above):
- Click ‘File’ at the top left corner
- Click on Encrypt with Password
- Enter your password and then verify it ….. write it down somewhere safe.
- Do Not Forget it because if you do there is no way to retrieve it !!!
- Click OK to save it.
Now you are DONE setting up your new password !
Written by Deborah @ (DCS) DatabaseCreationSite.com where Creative People Make Awesome Databases for Personal Use, Businesses, and For Writers.