English

Problem: Access crosstab queries are not listed under database connection

Description

ArcGIS does not list Access database crosstab queries for any OLE DB connection made using the Microsoft Jet 4.0 OLE DB provider.

Cause

This is a known issue.

Solution or Workaround

Make the connection to the Access .mdb file using an ODBC driver and the Microsoft OLE DB provider for ODBC drivers. Crosstab queries will appear listed under the OLE DB connection object.