Consider the following rules and guidelines for a Microsoft Access connection:
1You 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 .
2You 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.
3The Microsoft Access connection does not support Unicode (UTF-8) data. No tasks can read or write Unicode data from a Microsoft Access table.