Quick Books ODBC Driver Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get some data from a Quick Books file using QODBC driver into
Access. The tables can be linked okay but when the table is opened it takes a
long time to populate. After checking with the QODBC people they say their
driver works fine but that the problem is with Access.

This is what they say:.

http://www.qodbc.com/QODBCAutoFAQ.htm?faq_id=16&category_id=1

Access is overloaded with multi-user functionality, meaning that features
like updating all stations when a record changes on-line and other features
are easily accomplished by the native Access file format.

When Access uses ODBC however, it attempts to do the same thing. For
instance, when you open a multi-user grid on an ODBC data file, it must read
the entire file into memory before continuing. This continues in the
background, and when you press page-down, Access waits until the file has
been completely read before beginning another query of the entire file,
starting with the last record of the previous screen.

This makes sense.

Question: is there a way around this? I already have an Access database and
want to connect it to QuickBooks.

Thanks in advance.
 
Change the query to a query pass through. Then, create and execute a make
table query that uses the first query as its source. Don't even think about
using a linked table.
 
Back
Top