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=;