View previous topic :: View next topic |
Author |
Message |
mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Mon Aug 25, 2008 10:30 am Post subject: ODBC and Pass-through queries |
|
|
I've read on QODBC forums, that you can't really use regular queries on linked tables in MS Access because it is way to slow (due to the way access works with the data)
I have learned that this product works great with MS Access as long as you use SQL pass-through queries on large tables such as invoices, invoiceLine, Bill BillLine etc. SQL
Using Pass-through and the QODBC optimizer enable this product to be very fast and make it usable with MS Access.
You shouldn't need to use temporary "make table queries" if you use a pass-through query instead. (this should save you a step). Create your select query by using a pass-through query as your data source instead of using a "made-table" as your data source.
There are plenty of examples of how to create a pass-through query on the QODBC Forums. Pass through queries can only be written in SQL language but the "select statements" can be easily copied, pasted and modified from other sources and examples.
To create a pass-through query to use as your data source you will need to access the linked tables with an SQL specific query. (right click on on the query in design view to change query to SQL specific).
You will also need to enter:
ODBC;DSN=QuickBooks Data;SERVER=QODBC
in the ODBC Connect Str Field, which can be found by right clicking the top bar of the pass-through query in design view and editing the properties of the pass-through query. |
|
Back to top |
|
|
mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Mon Aug 25, 2008 10:38 am Post subject: |
|
|
Q:
Should I have a file DSN as shown in the Access instructions?
A:
No you should always use a QODBC SYSTEM DSN which in MS Access is shown as a MACHINE DATA SOURCE Type: SYSTEM.
I do suggest you turn off the driver status box |
|
Back to top |
|
|
mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Thu Sep 18, 2008 9:56 am Post subject: |
|
|
You will want to use SQL pass-through queries when using MS Access on large tables. (invoices, invoiceLine, Bill BillLine etc)
There are plenty of examples of pass-through queries on the QODBC Forums.
You don't want to use regular queries to access linked tables in MS Access. The process is way to slow due to the way access works with the data. SQL Pass-through and the QODBC optimizer make this product worth using with MS Access. |
|
Back to top |
|
|
|