MS Access Connection

A MS Access Connection can be used when you want to create for instance a connection on a Microsoft Access database or a personal geodatabase.

The name and the alias are defined for the MS Access connection. In the next step the connection to the database is created.

New MS Access Connection

New MS Access Connection

 

Select the type for the OleDB driver; on one hand the Access database can be an Office 2000-2003 (used driver: Microsoft.Jet.OLEDB.4.0) or an Office 2007 (used driver: Microsoft.ACE.OLEDB.12.0). Load the desired database (.mdb or .accdb) over the data path. In case your database is protected with a password, enter the password for the login.

Configuring Connection

Configuring Connection

 

Test the connection with the button Test Connection.

Configuring Connection 2

Configuring Connection 2

 

The connection string is displayed in the connection string window.

_img36

You can find more information about creating Connection Strings at http://www.connectionstrings.com/.