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.

_img66

 

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.

_img67

 

Test the connection with the button Test Connection.

_img68

 

The connection string is displayed in the connection string window.

msaccess4

icon_cross-reference

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