Wednesday, September 22, 2010

MS Query: Incorrect syntax near keyword ...

FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS"
(http://support.microsoft.com/kb/273813)

Bottom line:
Problem occured because there's a column name that conflict with SQL keyword

Solution:
Exclude the column from query OR upgrade to latest MDAC

No comments:

Post a Comment