Using Data Connector to import from Share Point results in errors/warnings displayed when attempting to view the data.
The Microsoft Access database engine could not find the object 'OBJECT NAME'. Make sure the object exists and that you spell its name and the path name correctly. If 'OBJECT NAME' is not a local object, check your network connection or contact the server administrator.
The import\export rule can be created and configured without pressing "View import data" on the 'Data Source page' or "Show data..." on the Rule Page (these actions try to load data in context of W3WP). During research we've found that we access the datasource data from IIS only when a user selects "Preview" options from the Console, that are not required for rule configuration and execution.
Attached is a PointFix for version 7.6 HF7.
HOW TO INSTALL THIS POINTFIX
Log in as administrator
Retrive files from the archive to the NS hard drive.
Click on PFinstaller.exe
Click install files button
HOW TO UNINSTALL THIS POINTFIX
Make sure that Backup subfolder is located in PFinstaller directory
Execute PFInstaller.exe with administrative privileges (right-click > Run as administrator).