Connection strings for Access

Standard security

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.

Workgroup (system database)

Workgroup (system database) specifying username and password

DataDirectory functionality

Network Location

Using RDS (MS Remote)

Access database over HTTP. You must setup RDS on the server for his to work.

Exclusive

Used to get exclusive access to the database if you, for instance, want to let the application be able to reset the database password.

Bridging to Jet OLE DB 4.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.

Standard Security

Workgroup

Exclusive

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.

Bridging to Microsoft Access ODBC Driver

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.