Error Messages/43104

< Error Messages
Revision as of 19:39, 16 March 2014 by Lchrisman (talk | contribs) (Created page with "= Example Error Message = :42000:[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. = Causes =...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Example Error Message

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

Causes

This error is issued by the database's SQL driver when DbQuery or DbWrite is evaluated. It indicates bad SQL, usually the first word in the SQL. For example, I encountered this when I misspelled SELECT.

Remedy

Fix the SQL.

See Also

Comments


You are not allowed to post comments.