Microsoft Access ODBC Driver connection strings

Access 97

• Standard Security

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Workgroup

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Exclusive

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• 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;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

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

  The above example uses the en-gb locale identifier (2057)

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2000

• Standard Security

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Workgroup

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Exclusive

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• 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;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

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

  The above example uses the en-gb locale identifier (2057)

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2002

• Standard Security

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Workgroup

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Exclusive

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• 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;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

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

  The above example uses the en-gb locale identifier (2057)

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2003

• Standard Security

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Workgroup

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Exclusive

  Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;
Uid=admin;Pwd=;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• 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;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

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

  The above example uses the en-gb locale identifier (2057)

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97