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
|
|
Upgrade to QB2009 - uninstalled QODBC ver 8 |
Author |
Message |
|
Posted : 2008-11-26 06:25:46 |
We just updated to QB2009 (from QB2008), and also updated QODBC (which is being use to read QB files into an Access application). I did not read the install directions and uninstalled QODBC ver8 before installing ver9. I'm now trying to read the QB tables from Access and it is taking over an hour so far. Is this because the optimzier is re-creating the temporary tables??? How long should this take.
Kelley |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-26 21:05:04 |
When you updated to QODBC v9 all the installation defaults got reinstated. For MS Access 2003 or 2007 to work correctly you must first check your optimization settings to use the The start of every new connection (with "Load Updated Data" first) option and confirm that the Multi-Table Sync option has been disabled. If not, uncheck the Multi-Table Sync option as this is often defaulted on (checked) with QuickBooks Enterprise and the QODBC Enterprise Desktop Edition.
Once this has been done, unlink all the QODBC tables in your existing MS Access .mdb(s) and then relink them to use these new connection settings.
For the complete details of all the QODBC optimizer settings, see: How do I setup the QODBC Optimizer? Where are the Optimizer options? |
|
|
|
|