Connection strings for Access
OLE DB providers for Access
.NET libraries for Access
- .NET Framework Data Provider for OLE DB - OleDbConnection
- .NET Framework Data Provider for ODBC - OdbcConnection
ODBC drivers for Access
Find solutions and post questions regarding connection string related issues.Forum for Access
Microsoft Jet OLE DB 4.0
With database password
This is the connection string to use when you have an access database protected with a password using the Set Database Password function in Access.
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.
Workgroup (system database)
Workgroup (system database) specifying username and password
Using RDS (MS Remote)
Access database over HTTP. You must setup RDS on the server for his to work.
Used to get exclusive access to the database if you, for instance, want to let the application be able to reset the database password.
.NET Framework Data Provider for OLE DB
Use an OLE DB provider from .NET
See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.
Microsoft Access ODBC Driver
Enable admin statements
To enable certain programatically admin functions such as CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (when making CREATE TABLE statements) use this connection string.
Specifying locale identifier
Use this one to specify the locale identifier which can help with non-US formated dates.
The above example uses the en-gb locale identifier (2057)
Microsoft Access accdb ODBC Driver
.NET Framework Data Provider for ODBC
Use an ODBC driver from .NET
See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.