Password Protect The Back End Of Your Microsoft Access Database

Password Protect The Back End Of Your Microsoft Access Database

There are two parts to the following video tutorial explaining how to password protect the back end of your Microsoft Access database where your first need to split the database and then exclusively open the back end database to apply an encrypted password.

Take a quick look how… 

You can also manually link and re-link tables from other databases which will in turn need to be individually password protected should you require the added protection for the more sophisticated system.

Password Protect The Back End Of Your Microsoft Access Database

In the video, it clearly explained that you first needed to split the MS Access database into two separate files which also offers other added benefits too.

The back end database contains just the tables but before applying a password to it, you need to first remove the linked tables from the front end database which was the result of the database splitter tool which it automatically converted.

password protect the back end microsoft access database

In order to set a single and encrypted password, remember to open the back end database in exclusive mode which means your are the only user who can work on the database locking out all other members.

Do note, this is just a single password for all users with no user identification required but since it’s for the back end database file, no one actually needs to be identified and a global password for should suffice.

When re-linking the tables back to the front end database, the password prompt will ask for verification which is then automatically remembered when re-opening the front end database file as the ODBC and password parameters are written to a hidden system table.

If your require a more sophisticated password system with user access and even workgroup access rights, then a custom solution is required here or perhaps looking at my own user login and access rights utility offer may be of interest to you!

Either way, to password protect the back end of your Microsoft Access database is a straight forward affair providing you follow the suggested order (as in the video tutorial).

Don’t forget to check out my Login and access rights utility offer.

Have a great week :)

This entry was posted in General and tagged , , , , . Bookmark the permalink.

2 Responses to Password Protect The Back End Of Your Microsoft Access Database

  1. Ben says:

    I think there is enough info for you to pick out and find more content on the web. Thanks.

  2. Kianoush M says:

    Thank you for your nice video and the great subject. I wish you could add more textual content with more images to your page. Good luck!

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.