OLE DB, Microsoft Access 97 Queries, and CONNX
Access 97 and Access 2000 databases contain both tables and queries. Some of the queries return tabular information. These queries can be treated as tables or views within CONNX with some limitations:Tables derived from queries cannot be edited. Care must be used with such tables if the resulting tabular data always varies, for example, if a query is designed to add a row to a table and then return a selection from that table. Every time that query is used, another row is added to that table, and it cannot be removed. Therefore, it is possible to issue an SQL statement that inadvertently accesses this table/query a number of times, yielding uncertain results.
Queries that do not produce tabular data in Microsoft Jet 3.51 OLE DB Provider may be presented as importable tables. In version 4.0 , however, queries that do not produce tables are not presented as importable objects. Do not try to import non-tabular queries into CONNX using the older 3.51 version of the Access OLE DB provider.