[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"

Cause

The field names contain spaces or special characters.

Solution or Workaround

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