Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Syntax error(missing operator) in query expression

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.

Published:

Syntax error(missing operator) in query expression

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.

For an optimal Community experience, Please view on Desktop