PROBLEM

Tables created from a SQL connection to Access queries show fields but no records

Last Published: April 25, 2020

Description

Tables added to a project via an SQL connection to an Access query are empty. The tables have all the appropriate fields but no records are present.

Cause

ODBC drivers may have trouble reading queries constructed using non-standard query syntax.

Solution or Workaround



  • Option 1: Use standard syntax to build the Access query.

  • Option 2: Export the Access query as a dBase IV table and add it to ArcView as a regular table.

    Warning:
    This method severs the live link between the database and the ArcView table.

Article ID:000002070

Software:
  • Legacy Products

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