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. |