Access crosstab queries are not listed under database connection

Last Published: April 25, 2020


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


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

  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options