[QODBC-Desktop] Troubleshooting - Cannot load Customer table records
Posted by Jack - QODBC Support on 20 February 2017 11:34 AM
Troubleshooting - Cannot load Customer table records.
I am trying to query the Customer table. The Title Bar of the Access Application says Not responding. Still, it never opens for me in the datasheet view, either double-clicking the table or running a query - no error message is ever returned, but the screen maintains an hourglass.
Please enable the QODBC status panel via QODBC Setup Screen->Message Window->Select "Display Driver Status" and "Display optimizer Status" options.
After enabling the status panel to execute the query again, if you see "Waiting for QuickBooks," it means QuickBooks is taking the time to process the request. There will be a status panel at the lower right corner of your screen, showing a window with information on what QODBC is working at.
Also, You may face this issue If your company file contains many records in CustomerShipToAddress.
To resolve this issue, Please download & install QODBC's latest version, V320 or above, by clicking here.
After downloading the latest QODBC version, please change the iterator chunk size to 2/10/50/100 on QODBC Setup Screen->Advanced tab.
After changing the chunk size, please query the customer table again. You should able to get records in the Customer table.