Why Encrypt?

There are many reasons to encrypt an MS Access Database. Personally, I only ever do it to protect my back ends user tampering and make sure I\'m in control of all direct data access. You might also encrypt to simply password protect your front end so not anyone can open it. (though I think doing this through code is a more modern and editable approach)

First, we need to open the database in 'Exclusive' mode

There are a few ways to do this (using a command-line switch in cmd or a shortcut is one) but we are going to do this in native MS Access. Go ahead and go to 'File' - 'Open' - 'Browse'

The file selector should appear. Now, find your database, click the little arrow next to 'Open' and select 'Open Exclusive'

Now, let's encrypt it.

Go over to 'File'

Now select 'Info', then 'Encrypt with Password'

Easy peasy - now just put in the password you want to use.

Not sure what password to use? I highly recommend using a generated password, like the one on LastPass. Then, you don't have to worry about how strong it is.

Notes on Encryption

If you're thinking this makes your Access Database infinitely secure, think again. In reality it's usually not that hard to get a password, especially if this is connect to a shift-enabled front end. The passwords are literally stored in plain text on the linked database.

Also, to remove the encryption you need to have your password on hand (as you would guess).

FYI - No password-protected app is any stronger than the storage of the password.