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

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