Troubleshooting - Cannot load Customer table records.

Problem Description:

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 by double-clicking the table or running a query; no error message is ever returned, but the screen maintains an hourglass.

I am getting the following error in QODBC logs:

2016-07-19 13:55:05 QODBC Ver: 16.00.00.313 *********************************************************************************************************************
service: False
SQL Statement: SELECT * FROM Customer
Error Getting XML in BuildAndLoadXMLForNextRecord

Solution:

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, run the query again. If you see “Waiting for QuickBooks,” it means that QuickBooks is still processing the request. The Status Panel, located in the lower-right corner of your screen, displays information about the operation QODBC is currently performing.

This issue may also occur if your company file contains a large number of records in the CustomerShipToAddress table.

When working with large record sets, you may need to adjust the Iterator/Chunk Size setting in the Advanced tab of the QODBC Setup Screen to accommodate the largest record set returned by QuickBooks. The default value is 500, but it can be increased to any value up to 100,000.

To resolve the issue, please download and install the latest version of QODBC (build 361 or later) from the QODBC Download page.

After downloading the latest QODBC version, please change the iterator chunk size to 2/10/50/100 on the QODBC Setup Screen->Advanced tab.

After changing the chunk size, please query the customer table again. You should be able to get records in the Customer table.