Connection strings for Access 2007
Providers to use when connecting to Access 2007
Finding this site useful?
-Say "Thanks" to Purusothaman A and the other contributing developers!
-Thank you! »
-Say "Thanks" to Purusothaman A and the other contributing developers!
-Thank you! »
ACE OLEDB 12.0
Type: OLE DB Provider
Usage: Provider=Microsoft.ACE.OLEDB.12.0
Usage: Provider=Microsoft.ACE.OLEDB.12.0
Manufacturer: Microsoft
Customize string example values »
Standard security
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;
With database password
This is the connection string to use when you have an Access 2007 database protected with a password using the "Set Database Password" function in Access.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;
DataDirectory functionality
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Persist Security Info=False;
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Customize string example values »
Bridging to ACE OLEDB 12.0
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;