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 QODBC |
Author |
Message |
SWT |
|
Group | : Members |
Posts | : 20 |
Joined | : 2006-11-09 |
|
Profile |
|
Posted : 2008-10-30 04:02:01 |
I am using MS Access to get data from 20 different companies through QODBC.
In order to get data from multiple companies, a few challenges needed to be overcome. The main one was figuring out how to get access to quit QBW32.exe between each new company. I have figured out how to do this using a .bat file and the command taskkill.
The other challenge I have (although minor) is that each time a new company is opened, an instance of QODBC (as seen in the system tray) is opened. By the time I am done running all the companies, I have 20 QODBC icons in my tray. (one for each company i have grabbed data from).
Without exiting MS Access, is there a way to get MS Access to release the use of QODBC?
The reason I am hopeful this can be done is that once I have grabbed data from say company 1 and then forced QBW32.exe to end, and then started getting data from company 2 and then forced QBW32.exe to end, I can no longer go back to company 1 and get data again from it unless I exit Access and get back in. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-30 11:32:13 |
|
|
|
SWT |
|
Group | : Members |
Posts | : 20 |
Joined | : 2006-11-09 |
|
Profile |
|
Posted : 2008-10-31 02:02:22 |
Thanks your for the idea.
However, I have already implemented those ideas into my database. By using pass through queries and the code for custom date ranges everything is working as I would have hoped, other than the fact that once I have pulled data from one company and moved onto another company, I am unable to then go back to the original company and pull data again unless I exit Access and get back in. This is due to the fact that each instance of QODBC is not released unless I exit Access.
Do you have any other ideas on how this could be accomplished? |
|
|
|
|