[Microsoft] [ODBC Microsoft Access 7.0 Driver] Too few parameters

Last Published: April 25, 2020

Error Message

When adding a Microsoft Access table to ArcView using an SQL connection, the following error may occur:

"[Microsoft] [ODBC Microsoft Access 7.0 Driver] Too few parameters.
Expected 1
SQL syntax error"


The field names contain spaces or special characters.

Solution or Workaround

In the select clause of the SQL statement, add square brackets around the table name and field name for fields with spaces or special characters. For example:

select [table1].[field-1], [table1].[field 2], table1.field3

Article ID:000002871

  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic