I have a subscription to Dynamics CRM Online, and I am using RSSBUS Dynamics CRM Connector to synchronize the data to SQL 2012 Database server. The data synchronize properly and SQL, I can open a table and see the data. When I try to connect Microsoft Access to SQL, I get #Deleted on all fields. I created an ODBC connection to the SQL database and was able to test connection.
I tried connecting using Microsoft Access 2003, 20010 and 2013. All with the same results.
Please let me know if there is anything I can do to fix this issue.
Thanks in advance for all your help on this.