Try disabling "Use Case Sensitive RefNumber Searches".

VB Demo did not return any records either. Tried with the sample data and got data to display. I did already try backups of my company file going back several months but still the same error. Any other ideas?

I'm having this same problem, except with the Invoice table.

I can open up the Sales Order table and Item tables without any difficulty, but I can't get into the Invoice table.  If I make a new QuickBooks company, I have no problem accessing the invoice table, which makes me think that the company file that I am using is corrupt.

I'm using Microsoft Access 2003, and QODBC 6.    I've tried Rebuild Data utility as well as the suggestion about unchecking the Case Sensitive RefNumber Searches box, which didn't help.

Is there anything else I can try?  Let me know if seeing the log would help.

Raja

Use VB Demo and try running:

Select * from Invoice unoptimized where TxnDate > {d'2007-01-01'}

Hi Tom,

Interesting... it gave me an hourglass for a couple of minutes, and then started to return about 6000 records (ya, I know, they do good business) ;)

In Access, I also just tried:

SELECT *
FROM Invoice unoptimized where TxnDate > #01/01/2007#;

It took a minute or so, but it worked too!  Thank you so much.  Was it the unoptimized clause which made it work?  Or was it a timeout issue?

Thanks again,

Raja

The unoptimized tag forces the query to be run in QuickBooks, just in case your optimized table was corrupted. You can drop using the tag. Seems the real problem here is the number of invoices. Without the where TxnDate > #01/01/2007#; clause there are too many invoices before a timout. For large company files you shouldn't query all rows in a table. Transaction queries should be limited to a start from transaction date.

See: MS Access - ODBC Call Failed on v7 with Timeout Error and How do I setup the QODBC Optimizer? Where are the Optimizer options?  for more.