You can use only the insert task operation for tasks that contain a Microsoft Access connection and a lookup defined in a field mapping. The task fails for all other task operations .

You cannot use multiple source objects in a

synchronization

task when the task contains a Microsoft Access source or target that uses primary and foreign keys.

The Microsoft Access connection does not support Unicode (UTF-8) data. No tasks can read or write Unicode data from a Microsoft Access table.