Microsoft Access Connection String Builder

See Also:

Use this dialog to specify the path and connection parameters for the database.

Database Path and File Name:

Select the database path and file name for the database file (such as a Microsoft Access MDB file).

Database Type:

Select the database type string and parameters. This is the database connection string, however, the database path specified above is represented by <<FileName>>.

Connection String:

This is the connection string for the connection to the source database. The database connection string will be assembled from the database type string specified above, and the <<FileName>> text will be replaced with the database path and file name specified above. Alternatively, you could enter the whole database connection string.

For connection to a Microsoft Access 2000 Database, at C:\MyData\Data.MDB, you would use the following connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source = "C:\MyData\Data.MDB";

Password Connection Strings

The following connection string usually works for Access databases requiring a password (blue indicates additional text for a password):

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<<FileName>>;Jet OLEDB:Database Password=<<password>>;

Where <<password>> is the password for the database.