ERROR

Geocoding using a Microsoft Access database table as the address table returns 'Syntax error (missing operator) in query expression'

Last Published: February 12, 2024

Error Message

Geocoding using a Microsoft Access database table as the address table results in the following error:

"There was an error trying to process this table.
General function failure [table name]
Syntax error (missing operator) in query expression 'field name'."

Cause

The address table contains a field or fields that either begin with a number, contains a space, or contains the '&' or '^' symbols.

Solution or Workaround

Edit the table using Microsoft Access to remove the number, space, or odd character in the field name.

Article ID: 000006082

Software:
  • ArcMap 8 x
  • ArcMap 9 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