SQL Syntax Errors Encountered Dialog Box

Microsoft Office Access 2003

Show All Show All

SQL Syntax Errors Encountered Dialog Box

Notifies you that the designer cannot parse the SQL statement in the SQL pane. This dialog box appears when you enter or edit an SQL statement in the SQL pane; and then you either switch to another pane, verify the query, or attempt to execute the query; and one of the following conditions applies:

  • The SQL statement is incomplete or contains one or more syntax errors.
  • The SQL statement is valid but is not supported in the graphical panes (for example, a Union query).
  • The SQL statement is valid but contains syntax specific to the data connection you are using.

    ShowTip

    You can check whether a statement is valid using the Verify SQL Syntax button.

The dialog box displays a message with the reason that the SQL statement cannot be parsed. Choose OK to proceed.