QODBC MS Access and QuickBooks - QuickBooks Crashes
Posted on 2010-08-12
Using Access 2007 , QODBC, and QB Enterprise 2010 R7 to prepare a report in Access
Using an SP_ report check detail , with a cleared status field
Combining with two transaction tables (check and check expense line table)
QuickBooks Crashes when we run the query for a time period greater than 12 months.
Number of records in the check table is 20,000
Number of records in the check expense line table is 25,000
The Query is selecting all check transactions within a date range and printing on
one line the columns for cleared status, memos, payee, address, amount
So to me this is a very simple report.
We can query for a 12 month period but when we query greater than 12 months
(we would like to query for 4 years of data). The QuickBooks aborts after 10 minutes
of running the query.
We set the iterator (chunk size) to 100,000
Can you offer any suggestions of what to do to solve this problem? The
QB file verifies fine. Do you need additional information?