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

Connect to Access Database

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.


The SQL Command timeout in seconds.


Path to the Access Database file.


Path to a Workgroup file if required.


The TABLE or 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.