Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature

Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature

Setting a password for Access database applications is a simple and straight forward affair and now as a standard way to apply such protection, Microsoft Access (from version 2007) provides the basic password encrypted feature which means a better secure way to stop unauthorised users opening your database file.

Take a quick look at this video tutorial stepping your through how to apply the encryption password method.

In this video, it covered the very essentials of setting a password and you may have noticed that each time you wanted to add, edit or even remove a password (applying decryption) you first had to open your database in ‘exclusive mode’ – so don’t bother double-clicking the desktop icon!

Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature

password for access database

What type of encryption does MS Access 2007/2010/2013 use?

Microsoft Access uses the Microsoft Cryptographic API. This means that it will support any cryptographic algorithm available within Windows as a Cryptographic Service Provider (CSP). This is a great improvement over earlier versions of Access, which only supported a built-in, weak encryption algorithm.

However as the video mentions, if you wanted to set multi-user level and their access rights, using the above approach is too basic and limiting (unless everyone was to share the same password).

With earlier versions of Access (pre 2007), you used to have workgroup security utility allowing you to create multiple users, groups and set access rights to individual objects and was dropped with the introduction of ACCDB database file formats.

What has it been replaced with?

Simple answer is there is no replacement but instead you need to promote your database into Microsoft SharePoint Services environment instead which will control access rights and user accounts not just for your Access database files built other Microsoft applications too.

Alternatively, why not consider my custom built user login tool (for any version) which will give you all the control and the ability to customise further the ‘open source’ VBA code and control how you set a password for Access database applications.

Take a quick look at the video tutorial from the offer page and what I promise to deliver:

UK visitors: Building Your Very Own Access Database Security – Login User Form Utility

US visitors: Building Your Very Own Access Database Security – Login User Form Utility

A great value piece of software, fully customisable and with a 30 day email support not to mention it’s fully guaranteed - which means a ‘no money back policy’ – what do you have to lose?

This entry was posted in Microsoft Training, MS Access, Utilities and tagged , , , , . Bookmark the permalink.

2 Responses to Password For Access Database: How To Set Database Passwords Using The Simple Encrypt Feature

  1. Ben says:

    Hello Stuart,
    You should have been automatically redirected to the PDF file which has all the nor ation required.
    I have sent you an email with the link to the PDF file.
    Kind Regards
    Ben

  2. Stuart Lyall says:

    Hi Ben
    Once I’ve made the payment, how do I receive the guide? I have made the payment now just awaiting the link I guess?

    Thanks

    Stuart

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=""> <strike> <strong>