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.
Now navigate to File tab and in backstage view click Encrypt With Password.
Now set a password to encrypt database and click OK.
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.
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.