Skip to main content

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.

Was this article helpful?

We're sorry to hear that.