N/APosted on - 04/07/2012
Good day experts!
I'm planning on setting a password for my MS Access file.
This file serves as my database on one of my program created.
What steps should I do to set a password on my MS Access file?
Setting a Password for my MS Access DB
To create a password for your MS Access files:
- Close the database first. In case it is a shared file, make sure that all of your users have also closed the file.
- Make sure to create a backup copy of your database and have it stored in a secure place.
- Go to File menu and click on Open
- Click on the arrow to the right of Look In box and select the drive and the folder where the file is located then click on the database’s icon.
- Click on the arrow to the right of Open button, then click the Open Exclusive option
- On Tools menu, go to Security and the click on Set Database Password
- Enter your password
- Verify and confirm the password
- Click on OK
- Microsoft Access passwords are not encrypted so to avoid compromising your files’ sensitive data, use the user-level security instead
- If you lose or forgot your password for your database, it cannot be recovered thus hindering you from opening your files
- Do not use a password if you will replicate your database because they can’t be synchronized if the password has been defined
- There is no way for you to create a password for your file if you the user-level security has been defined on your database
To understand creating, changing or removing password on Microsoft Access database better, please go to link.