Page 1 of 1

Zoho CRM ODBC with MS Access

Posted: Thu 14 Feb 2019 21:25
by rocketraman
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:

* ... as-deleted
* ... 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?

Re: Zoho CRM ODBC with MS Access

Posted: Fri 15 Feb 2019 15:48
by MaximG
The behavior you described is a functional peculiarity of Microsoft Access and we cannot change it.

Re: Zoho CRM ODBC with MS Access

Posted: Tue 23 Apr 2019 21:30
by jlescano
I managed to get past this problem by activating the "Support Large Number (Bigint) datatype for linked/imported tables" in MS Access Options - Current Database. I am using MS for Office 365 32bits, latest patch.

Now, when I link all tables, I get an error in some of them:
• Contacts / Leads ERROR: [DEVART][ODBC][Zoho CRM] Zoho Native Type 'consent lookup' (#2)
• Data_Subject_Requests ERROR: [DEVART][ODBC][Zoho CRM] Object 'Data_Subject_Requests' does not have field 'Owner' (#2)
• Solutions ERROR: [DEVART][ODBC][Zoho CRM] Object 'Solutions' does not have field 'Product' (#2)

Past that point, I face a new problem: while some tables (e.g. User, Activities) work perfectly, when trying to open other tables I get the message “ODBC—Call Failed” and MS Access displays "#Name?" in all fields:

As in the case reported in the previous post, if I make them Local tables the problem is over, but so is the ability to update from MS Access.

Is this a bug? Any idea how to resolve these problems?
Thanks a lot.

Re: Zoho CRM ODBC with MS Access

Posted: Thu 25 Apr 2019 14:22
by MaximG
We have fixed the issue related to the occurrence of the "#Name?" value in all fields. As a temporary workaround, we can provide you with a night build of our product. For this, please specify your license number via the e-support form ( ).
Please also specify in detail the steps for reproducing the issue related to the work of the Contacts /Leads linked tables.