Inexplicable Syntax Error in INSERT or UPDATE Statement? See this List of Microsoft Jet 4.0 Reserved Words

Last post 04-17-2005 4:14 PM by tmorton. 0 replies.

Sort Posts:

  • Inexplicable Syntax Error in INSERT or UPDATE Statement? See this List of Microsoft Jet 4.0 Reserved Words

    04-17-2005, 4:14 PM
    Locked
    • All-Star
      41,151 point All-Star
    • tmorton
    • Member since 08-06-2002, 5:37 PM
    • SE Pennsylvania, USA
    • Posts 6,824
    • ASPInsiders
      Moderator
    Thank you to imagemaker for pointing out KB article 321266, which contains the list of reserved words for Microsoft Jet 4.0.

    If you see an inexplicable "syntax error" message when trying to execute a SQL statement, a reserved word is the first place to look.  If you find that you have used any of these reserved words for column names, you will need to enclose the column name in square brackets whenever you use it in an a query.

    Password and User are two reserved words that seem to be frequently used as column names.



    Terri Morton
    Engagement Manager, Neudesic
Page 1 of 1 (1 items)