We help IT Professionals succeed at work.

SQL data is showing #Deleted when connecting using Microsoft Access

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.

Bill
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
the table does likely not have a primary key in the SQL Server side.
please create such a constraint, and it should work much better;

if you cannot do this on the sql server side, add such a key/index on the access side, that will also help, normally
Distinguished Expert 2017
Commented:
Try changing the ODBC driver to use SQL Server Native Client 10.0 (or newer)

Author

Commented:
I can not modify or add to SQL.  But how do I add an index key on the access side if it is a linked table?
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented: