English

Error: Syntax error (missing operator) in query expression

Error Message

This message is returned during Interactive Selection on Access GeoDatabase:

There was an error executing the query.
General Function Failure [1layer_name]
Syntax error (missing operator) in query expression ‘(1layer_name.OBJECTID = 1layer_name_Shape_Index.IndexedObjectId and MaxGx >= 2 and MinGX <= 2 and MaxGY> = 0 and MinGY <= 0)’.

Cause

Personal Geodatabase Access layer features cannot be selected if the name of the layer starts with a number.

Note:
Database management systems have different definitions of acceptable characters for object names. Most names must begin with a letter and cannot contain spaces, backslashes, or reserved database management system keywords. Some databases allow special characters such as forward slashes (/), underscores (_), dollar signs ($), dashes (-), dots (.), or mixed cases. Sometimes the database allows you to use special characters or reserved keywords, or force mixed, upper-, or lowercase names if you provide the object name enclosed in delimiters, such as double quotation marks.

However, ArcGIS does not delimit object names. Do not create any tables, feature classes, indexes, databases, users*, roles, or other object names that require delimiters if you will be using them with ArcGIS. The object will be created in the database, but you cannot access it from ArcGIS.

*SQL Server user names containing special characters are delimited to fully support Active Directory Groups and Windows Authenticated logins; however, ArcGIS does not support user names containing single quotation marks or apostrophes.

Solution or Workaround

Rename the Feature layer to not begin with a number.

Related Information