PROBLEM

Access crosstab queries are not listed under database connection

Last Published: April 25, 2020

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.

Article ID:000004601

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback