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
Incorrect syntax in the SQL statement.
Refer to the Microsoft Access Help documentation to ensure you are using the correct syntax.
Get help from ArcGIS experts
Download the Esri Support App