Microsoft Access ODBC Driver connection strings
Access 97
-
Standard Security
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
-
Workgroup
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw; -
Exclusive
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=; -
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.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
ExtendedAnsiSQL=1; -
Specifying locale identifier
Use this one to specify the locale identifier which can help with non-US formated dates.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Locale Identifier=2057;Uid=Admin;Pwd=;
Access 2000
-
Standard Security
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
-
Workgroup
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw; -
Exclusive
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=; -
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.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
ExtendedAnsiSQL=1; -
Specifying locale identifier
Use this one to specify the locale identifier which can help with non-US formated dates.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Locale Identifier=2057;Uid=Admin;Pwd=;
Access 2002
-
Standard Security
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
-
Workgroup
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw; -
Exclusive
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=; -
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.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
ExtendedAnsiSQL=1; -
Specifying locale identifier
Use this one to specify the locale identifier which can help with non-US formated dates.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Locale Identifier=2057;Uid=Admin;Pwd=;
Access 2003
-
Standard Security
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
-
Workgroup
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw; -
Exclusive
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=; -
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.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
ExtendedAnsiSQL=1; -
Specifying locale identifier
Use this one to specify the locale identifier which can help with non-US formated dates.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Locale Identifier=2057;Uid=Admin;Pwd=;
Connect
Articlesread all »
- Jet for Access, Excel and Txt on 64 bit systems
- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
- Formating Rules for Connection Strings
- Connection Strings Explained
- Store Connection String in Web.config
- Connection Pooling
- The Provider Keyword, ProgID, Versioning and COM CLSID Explained
- SQL Server Data Types Reference
- Network Protocol for SQL Server Connection
- All SQL Server SqlConnection Properties
Didn't find your connection string?
Start over from the connection string reference index - or try a search!
In the Q&A forums you can ask your own question and let somebody help you.
The knowledge articles contains solutions and guides.