How to Password Protect an MS Access Database

When comes to PCs and the information they keep, be it on servers or drives, security of such information is perhaps the most important thing for anybody. If that be the case, there is nothing as sensitive as databases and the need to protect them has never been more crucial. As such, it is important to protect an MS database with a password so that your sensitive information is safely secured from any theft or abuse by any parties.

Security is Important

Security is important and protecting your MS database helps you protect it from third parties that might want to access your sensitive information or data illegally. My aim here is to take you on a step by step account over how to go about protecting your database with a password if you are an MS Access frequent user. We all that MS Access is one of those can’t do without database programs because it is versatile, affordable and relatively easy to use. As such, you have employed it at one time or the other in your business and certainly know how crucial business information can be. Thus as a business user of MS Access, sometimes you will have multiple databases and protecting these from prying eyes is quite significant for your business. Luckily for you, MS Access comes with features that let you password your databases so they are safe and secure from prying third party eyes.

To Protect Your MS Access Databases

First of all, maneuver to the MS Access database you want to protect and open it. Once it is open, if you are using MS Access 2003, just go to Tools menu and pick Security, select Set Database Password tab. However, if you are using MS Access 2007, simply go to the Database Tools icon and select the tab Encrypt with Password under the Database Tools group. When here, simply enter the password you like in the Password box and repeat the same password you have chosen under the Verify space bar. Once you have done that simply click OK.

Now move to the tools menu if you are using MS Access 2003 and under the Security, select User Level Security Wizard and click on it. However, if you are using MS Access 2007, move to the Database Tools and click Users and Permissions under the Administer group tab. Select User Security Level Wizard and it will open immediately. Now go to the Create a New Workgroup Information File and click to advance to the next option, for which you should just write the information the wizard will ask you for, choose the database you need protected and then advance with next. On the next tab, select groups you want to have included in the workgroup information file and then advance by clicking next. You are almost done, just click on Permissions if there is any and advance with next where you will now include user names and just click on finish to protect your databases.

Leave a Reply

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