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
|
|
sp_report in MS access using multiple quickbook files |
Author |
Message |
SWT |
|
Group | : Members |
Posts | : 20 |
Joined | : 2006-11-09 |
|
Profile |
|
Posted : 2006-11-14 03:14:15 |
I am building a custom detail transaction report table in MS access using sp_report and passthrough queries for several QB companies. By stacking several append queries I am able to grab data from multiple companies into one master table. My challenge is that after the first append query is finished on the first company, the next append query fails with a QODBC error. The problem is that when my first query is run, it starts the QBW32.exe file and does not let go of it: I have to manually release this file using the task manager.
Does any one know of a workaround that can be automated? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-14 08:26:13 |
MS Access will normally only release the QODBC connection when the MDB is closed. If you have LINKed QODBC tables, you can try removing them and inserting a delay between the append queries. Each of the appends will need to use a different DSN with the name of the company file to use.
Try looking at: Running an sp_report in Access using VBA |
|
|
|
|