I am using QB pro 2006 with all the latest updates.  There are currently 2196 customers in my QB db.  When I use QODBC in my VB.net app and attempt to get all these customers, I only get 2185 of them.  There does not seem to be any common feature with the missing customers that I can determine.  When I run VBdemo32.exe, I miss the same customers.  I have verified the data and backed up and restored the data.  It all appears fine in QB but not when read with QODBC.  I am using the following connect string: 

"PROVIDER=QODBC;DRIVER={QODBC Driver for Quickbooks};DFQ=" & <my QB file>

sp_optimizefullsync customer

or you can by-pass the optimized table by doing:-

select * from customer unoptimized

Please update QODBC to v6.00.00.155 (or later) for our fix to the optimizer.

I'm having the same problem. I've linked a QuickBooks file to an MS Access database via QODBC. One line item in quickbooks (a journal debit) did not appear when i opened the JournalEntryDebitLine. The JournalEntryDebitLine table should have 30 rows but QODBC only sees 29. I turned off optimizer in DNS and opened the table again. Now I get 30 rows but one is populated with #DELETED in each field. I tried querying the table with the VB Demo 32 and I get all 30 rows as expected. When i deleted and reentered the problem row in quickbooks, QODBC saw the row in Access so all 30 rows appeared.

We need to rely that all rows that are in QB are visible in MS Access. Any ideas how to resolve this?

To tell you the truth, MS Access is the main problem here as once you connect a linked table, it will store the connection string so if optimizer is on when you first connected and you later switch it off, it will be still be on using Access.

For critical operations I always use a pass-thru query as I can control the exact SQL and connection settings, see: How do I create a Pass-Through Report using Microsoft Access 2003?  for more info.

The pass thru query returned all 30 rows so this issue is resolved for me.

Thanks...