How to set database password in Microsoft Access 2010

Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step. Please note that these instructions are specific to Microsoft Access 2010. If you are using an earlier version of Access, read Password Protecting an Access 2007 Database.

 




Open Microsoft Access 2010 and open the database that you wish to password protect in exclusive mode. You may do this by selecting Open from the file menu and navigating to the database you'd like to encrypt and then click it once. Then, instead of just clicking the Open button, click the downward arrow icon to the right of the button. Choose "Open Exclusive" to open the database in exclusive mode.

1. When the database opens, go to the File tab and click the Info button.
2. Click the Encrypt with Password button.
3. Choose a strong password for your database and enter it in both the Password and Verify boxes in the Set Database Password dialog box, as shown in the image above. Once you've done this, click OK.
4. That's all there is to it. After clicking OK, your database will be encrypted. (This may take a while depending upon the size of your database). The next time you open your database, you'll be prompted to enter the password before accessing it.

Tips:

1. Choose a strong password for your database. It should contain both uppercase and lowercase letters, digits and symbols.
2. Be sure to choose a password you can easily remember. You'll need it the next time you wish to open your database!

Read More

Connection Visual Basic 6.0 to Microsoft Access 2010

Microsoft ACE OLEDB 12.0

Standard Security

    | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
    | Persist Security Info=False;

With database password
This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.

    | Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
    | Jet OLEDB:Database Password=MyDbPassword;

Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

Network Location

    | Provider=Microsoft.ACE.OLEDB.12.0;
    | Data Source=\\server\share\folder\myAccessFile.accdb;

Microsoft Jet OLE DB 4.0

Standard security

    | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;
    | Password=;

With database password

    | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;
    | Jet OLEDB:Database Password=MyDbPassword;

Network Location

    | Provider=Microsoft.Jet.OLEDB.4.0;
    | Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;
    | Password=;

Microsoft Access accdb ODBC Driver

Standard Security

    | Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;
    | Uid=Admin;Pwd=;

Exclusive

    | Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;
    | Exclusive=1;Uid=admin;Pwd=;

Microsoft Access ODBC Driver

Standard Security

    | Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

Exclusive

    | Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
    | Uid=admin;Pwd=;

Read More