I have created a MS Access database that is trying to read the INVOICE file. When I run the query it comes back with no records. I know the file has records dating back to before 2000. I have tried using the SQL statement

                          Select * from Invoice unoptimized

When I run this statement QuickBooks stop running, and I get a dialog box that asks me to retry or switch to.

I have run the SDK Log, and I am getting the following message

20071029.170000 I 1856 RequestProcessor ========= Started Connection =========
20071029.170000 I 1856 RequestProcessor Request Processor, QBXMLRP2 v5.0
20071029.170000 I 1856 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20071029.170000 I 1856 CertVerifier The file does not contain an Authenticode signature.
20071029.170000 I 1856 RequestProcessor Opening the file in the DoNotCare mode.
20071029.170112 I 1856 RequestProcessor Connection closed by app named 'FLEXquarters QODBC'
20071029.170112 I 1856 RequestProcessor ========== Ended Connection ==========

I have run the QODBC log, and I am getting the following message

2008-02-14 16:21:26 QODBC Ver:  6.00.00.134 *********************************************************************************************************************
IsAService: False
SQLOptimize_SQLClose finalize:
not an error

Please advise as to why this might be happening.

When I run the same query on the customer file, I do not have the same problem, I believe it has to do with the size of the file.

Thanks,

Howard