Microsoft Access Database

The Microsoft Access Database provider connects to a Access Database via the OleDB Microsoft.ACE.OLEDB.12.0 ADO.NET Client Library.

Download the Office 2010 runtime for the OleDB Driver, note for Data Sync 64-Bit you will need to install the 64-Bit version https://www.microsoft.com/en-gb/download/details.aspx?id=13255

SELECT, INSERT, UPDATE and DELETE SQL Statements are automatically calculated from the Data Schema. Only those columns in the Schema Map are affected the Key(s) columns define the WHERE condition for UPDATE and DELETE.

In Incremental Mode the IN clause is used to return matching records based on the Key selection in groups of 100.

CommandTimeout

The SQL Command timeout in seconds.

FileName

Path to the Access Database file.

WorkgroupFileName

Path to a Workgroup file if required.

SourceTable

The TABLE or VIEW that the Data source is connected to.

Command

A user defined SQL Query to use instead of SourceTable setting this property overrides SourceTable and makes the Data source read-only.

Data Sync wraps your command text so it appears as an inner query SELECT * FROM (<SQL_QUERY>) T1 to support schema discovery.