D
Daron
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.
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.