Password Protect Access 2010 Database (Encrypt / Decrypt)

Encryption is the cryptographic phenomena which enables you to cipher the content through a special key, eventually preventing any external source to pry in to it. Access 2010 also provides it’s users to encrypt the database with a key, i.e, password. Security of the database must be the first thing you need to ensure about. By following a simple procedure, you can make your database more resilient which mitigates the probable risk of prying from any authenticated source.

For protecting database we need to open it exclusively. For this launch Access 2010 and On File menu click Open.

Now select the database file on which you want to add protection and from Open options click Open Exclusive, as shown in the screenshot below.

exclusive1 Password Protect Access 2010 Database (Encrypt / Decrypt)

Now navigate to File tab and in backstage view click Encrypt With Password.


Now set a password to encrypt database and click OK.

set password

On opening database you will be asked to enter the passphrase for verification purpose.


If user is authenticated, then he will be able to use database. For decrypting database, you need to open it again in exclusive mode. Once opened in exclusive mode, from backstage view click Decrypt Database.

decrypt 1

Upon click, Unset Database Password dialog will appear asking for password to decrypt database. It’s that easy.


You can also check out previously reviewed guides on Applying Field Validation & Message and How to Create Index In Access 2010.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *