[Microsoft] [ODBC Microsoft Access 7.0 Driver] Error in assignment (null)

Error Message

This error occurs when adding an Access table to ArcView using an SQL connection with a 'Where' clause in the SQL statement:

[Microsoft] [ODBC Microsoft Access 7.0 Driver] Error in assignment (null)" which is followed by a "SQL Syntax Error

Cause

Incorrect syntax in the SQL statement.

Solution or Workaround