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
|
|
MS Access and QBW32.exe |
Author |
Message |
SWT |
|
Group | : Members |
Posts | : 20 |
Joined | : 2006-11-09 |
|
Profile |
|
Posted : 2008-10-22 06:03:21 |
When I run an SP_Report using Excel the QBW32.exe file initiates during the data pull and then stops once the data is finished being pulled. If I run an SP_Report using MS Access, the QBW32.exe file initiates during the data pull, but once the data is finished being pulled, the QBW32.exe file still remains open.
Am i doing something wrong in Access? Is there a way to use Access and have the QBW32.exe file exit (like it does in Excel?) once the SP_Report is finished running? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-22 08:23:45 |
No Microsoft Access is doing the wrong thing. Some bright spark thought to make MS Access not seem so slow, let's just keep everything open. So in your case you need to exit MS Access for QBW32.exe to close. |
|
|
|
SWT |
|
Group | : Members |
Posts | : 20 |
Joined | : 2006-11-09 |
|
Profile |
|
Posted : 2008-10-22 08:34:46 |
That is too bad since I need to grab data from 20 different QB companies and need to reset the QBW32.exe between each data pull. Any other ideas on how to do this through Access w/o having the QBW32.exe file getting in the way? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-22 08:45:24 |
Sorry this is a MS Access support issue, there's nothing wrong with QBW32.exe. But you can try the MakeTable technique shown in: Running an sp_report in Access using VBA instead. However, for this to work, don't link any QODBC tables at all. |
|
|
|
SWT |
|
Group | : Members |
Posts | : 20 |
Joined | : 2006-11-09 |
|
Profile |
|
Posted : 2008-10-22 10:19:00 |
Here is the solution I have come up with.
Using the Access macro feature I run all 20 queries which pulls data from the 20 different companies needed. Between each data pulling query I use the MS access "RunApp" feature which points to a .bat file with this command inside of it: "taskkill /F /IM QBW32.exe /FI "USERNAME eq username" where lower case username is equal to your username as identified by your system.
I have tested this and not once did my MS Access macro crash going between companies being pulled from.
|
|
|
|
|