Symptoms
When attaching an Access data source, you may receive the following error message.
"System.Data.Odbc.OdbcException
Error[42000] [Microsoft][ODBC] Microsoft Access Driver] Syntax error (missing operator) in query expression '{name}'."
Cause:
This error message is caused when the escape character configured in the Jet Data Manager does not match the escape character being used in the data source.
Resolution
To resolve the issue, change the escape character to the one that matches your data source.
Then, click Test Connection to ensure you are able to connect.
Comments