ERROR

Microsoft Access driver could not find input table for query < name of table >

Last Published: April 25, 2020

Error Message

This error occurs when clicking the Query button on the SQL Connect dialog box, after connecting to an Access database:

Microsoft Access driver could not find input table for query <name of table>

Cause

The name of the table and/or the field names in the table may contain space characters. You will not be able to add such a table to ArcView.

Solution or Workaround



  1. Open the database in Access.
  2. Check the table and column field names. Remove any space characters.

    Though underscores in a name are acceptable (Field_name), they are not recommended because some drivers may have problems with special characters.

    Note:
    This is a Microsoft driver error, not an ArcView error.

Article ID:000002534

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