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.