Hello,

I'm having a problem accessing the QB Transaction table data using this driver. I've tried using the driver with MS Access and the VB demo that comes with QODBC, but with no prevail. As soon as I run any query on the Transaction table both QB and QODBC stop responding. We'll waiting 6 hours and never see a change. Other tables work fine, it's just this one.

I've run data rebuild on the QB data file and checked everything I can think of. Any ideas whether this is a QB issue or QODBC failing?

Thanks in advance! 

The Transaction table will contain a large amount of transaction lines, so a:

SELECT * FROM Transaction

query will take forever. While limiting the transactions to say only transactions modified this month (Dec 2006) is better:

SELECT * FROM Transaction where TimeModified >= {ts '2006-12-01 00:00:00.000'} and TimeModified < {ts '2007-01-01 00:00:00.000'}

You should optimize the Transaction table by running:

sp_optimizeupdatesync Transaction

in VB Demo first and then use the NOSYNC tag in your MS Access queries like this:

SELECT * FROM Transaction NOSYNC

SELECT * FROM Transaction NOSYNC where TimeModified >= {ts '2006-12-01 00:00:00.000'} and TimeModified < {ts '2007-01-01 00:00:00.000'}

See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more on using the QODBC Optimizer.