Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
QODBC in MS Access |
Author |
Message |
|
Posted : 2008-12-11 08:53:22 |
I'm new to using QODBC and have much slower response when accessing QB tables in MS Access versus VB Demo. They also exhibit different Query behavior. As an example, when using VB Demo to simply query Purchase Orders (SELECT * FROM PurchaseOrder) runs quickly and returns 532 Purchase Order rows. The Hour Glass icon in the System Tray quickly changes back to the Q and the Driver Status Panel popup window disappears. I have succesfully Linked QB tables to a new Access Database. When running the same query from Access, it takes 2-3 times as long to run and even after the 532 rows are retrieved, the Hour Glass icon in the System Tray stays active and the QODBC Driver Status panel popup window never disappears. The QODBC Driver Status displays PurchaseOrder; Find Next Record; 1 of 1 and the time just continues to tick away... Is this normal behavior? If not, any suggestions to improve performance and cure this problem. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-12-11 10:39:36 |
|
|
|
|