Connection Tab for Jet

Use the Connection tab to specify how to connect to Microsoft Access data.

This Connection tab is provider-specific and displays only the connection properties required by the OLE DB Provider for Microsoft Jet.

Option

Description

Database name

Type the Microsoft Access database (.mdb) file name that you want to access.

User name

Type the User ID to use for authentication when you log on to the data source.

Password

Type the password to use for authentication when you log on to the data source.

Blank password

Enables the specified provider to return a blank password in the connection string.

Allow saving password

Allows the password to be saved with the connection string. Whether the password is included in the connection string depends on the functionality of the calling application.

Note

If saved, the password is returned and saved unmasked and unencrypted.

Test Connection

Click to attempt a connection to the specified data source. If the connection fails, ensure that the settings are correct. For example, spelling errors and case sensitivity can cause failed connections.

Remarks

Note

For more Data Link connection information, see the Data Link API Overview on MSDN.