This KB article will go over how to resolve the "Retrieving the COM class factory for component with CLSID" error message when trying to synchronize the data source or Deploy a table in the project.
To resolve this error message you will need to install the 32-bit version of the Jet Data Manager. Or you can turn off the use of SSIS and use ADO.NET. For more information on this error please see this Microsoft KB article. We also have a KB article that shows you how to disable SSIS and use ADO.NET here