Microsoft Access Connection strings - Connectionstring Examples

Connection strings Examples for Microsoft Access 2007

.NET Data Provider for OLE DB

This is a .NET class library from Microsoft. The namespace for this provider is System.Data.OleDb.OleDbConnection

Standard Security:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\data\yourAccessDatabase.accdb;Persist Security Info=False;

NOTE: The new Access format is accdb and the old format is mdb. To convert the old database to a newer format you can try
convert access to new format.

ACE OLEDB 12.0

This is a OLEDB driver from Microsoft. The usage is Provider=Microsoft.ACE.OLEDB.12.0

Standard security:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\data\yourAccessDatabase.accdb;Persist Security Info=False;

Including Password:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\data\yourAccessDatabase.accdb;Jet OLEDB:Database Password=yourDbPassword;

DataDirectory functionality:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\yourAccessDatabase.accdb;Persist Security Info=False;