To connect to your Access Database, set the following properties:

Connection Properties

• Data Source: The path to the Access database. Sync must have read/write permissions to the database.
• Provider: The OLEDB Provider. For MS Office 2007 and above, use Microsoft.ACE.OLEDB.12.0

Windows Edition

Connecting to Access as a destination requires the Microsoft Access Database Engine which can be downloaded from here: https://www.microsoft.com/en-US/download/details.aspx?id=13255

Be sure to download the correct bitness of the driver as 64bit MS Office only works with the 64bit driver. If using 32bit MS Office, you will need to host Sync in IIS and enable 32-bit applications. This can be set in the “Advanced Settings” for you Application Pool. Refer to Configuring in IIS for more information on hosting CData Sync in IIS.