Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Syntax error(missing operator) in query expression


Symptoms

When attaching an Access data source you may receive the following error message.

Complete text from 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?
0 out of 0 found this helpful

Comments