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
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
In Incremental Mode the
IN clause is used to return matching records based on the Key selection in groups of 100.
The SQL Command timeout in seconds.
Path to the Access Database file.
Path to a Workgroup file if required.
VIEW that the Data source is connected to.
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.