By the sounds of things you're not using QODBC v6.00.00.155 (or later) yet. You should download the latest version of QODBC as we have made big improvements to the QODBC Optimizer. See: How do I get the latest updated version of QODBC?
The second issue here is that any critical operation, such as Sales commissions must be done by a forced query statement to call QuickBooks. This is done by using the unoptimized tag after the table, for example:
select * from InvoiceLine unoptimized
or you can force a resync of the InvoiceLine table by doing a:
sp_optimizefullsync InvoiceLine
This is done by doing a pass through query in Access. See: How do I create a Pass-Through Report using Microsoft Access 2003? The job of the QODBC Optimizer is to allow fast access to lookup and historical information, however it's easy to trick the optimizer, like for example restoring a QuickBooks company file backup from 3 hours ago. |