Settings for Microsoft Access
This topic describes how to set up Access for DataSync.
-
In DataSync, create a new source connection for Access.
-
Fill out the fields in the New Connection dialog box as described below.
-
Click Save.
Connection Properties | Description |
---|---|
Description | Enter a name for the source connection. |
File Path | Enter the location of the Access file (.accdb). Note that encrypted Access databases are not currently supported; however, when you password-protect a database in the Microsoft Access GUI, you have the option to set a password without encrypting. If you have set a password for your database without also encrypting it, specifying the path to the database in this property is sufficient. |
Verbosity |
The verbosity level that determines the amount of detail included in the log file. Verbosity levels range from 1 to 5; the default is 3. |
Enable Pooling |
This parameter enables connection pooling. When it is selected, the three following properties are displayed:
|