Zoho CRM ODBC with MS Access
Posted: Thu 14 Feb 2019 21:25
Trying to link tables using the Zoho CRM ODBC driver with MS Access 2016. I get the message "ODBC-Call Failed" (sometimes), but whether or not the ODBC Failed message comes up, Access always shows the rows in the table with every value showing "#Deleted".
I tried the same connection with Excel, and am able to pull data into Excel.
Having researched this, it looks like this happens when Access tries to stuff an Id / primary key value into a column which is too small, or when the value stored by Access does not match the value stored in the backend. See:
* https://stackoverflow.com/questions/966 ... as-deleted
* https://dba.stackexchange.com/questions ... rough-odbc
The ID values coming back from the driver look like this: 2914909000000136011.
Using a "local table" works, but not a linked table -- the local table is ok for queries, but obviously won't work well for any type of updating.
Anyone have a solution for this failure of Access to properly link to Zoho CRM data via the ODBC driver?
I tried the same connection with Excel, and am able to pull data into Excel.
Having researched this, it looks like this happens when Access tries to stuff an Id / primary key value into a column which is too small, or when the value stored by Access does not match the value stored in the backend. See:
* https://stackoverflow.com/questions/966 ... as-deleted
* https://dba.stackexchange.com/questions ... rough-odbc
The ID values coming back from the driver look like this: 2914909000000136011.
Using a "local table" works, but not a linked table -- the local table is ok for queries, but obviously won't work well for any type of updating.
Anyone have a solution for this failure of Access to properly link to Zoho CRM data via the ODBC driver?