Error Messages/43104

Example Error Messages

42000:[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

42000:[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORM Asset'.

Causes

This error is issued by the database's SQL driver when DbQuery or DbWrite is evaluated. It indicates bad SQL syntax.

I encountered from this when I misspelled SELECT: "SELEC * FROM Asset"

I encountered the second message when I misspelled FROM: "SELECI * FORM Asset"

Remedy

Fix the SQL.

See Also

• DbQuery, DbWrite