Setting a Password for my MS Access DB

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

Warning:

• 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.