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.