Access Databases and AccessDataSource Controlhttp://forums.asp.net/55.aspxDiscuss using Access as a data store for ASP.NET, and the AccessDataSource control.enCommunityServer 2007 SP1 (Build: 20510.895)Inexplicable Syntax Error in INSERT or UPDATE Statement? See this List of Microsoft Jet 4.0 Reserved Wordshttp://forums.asp.net/thread/896117.aspxSun, 17 Apr 2005 20:14:27 GMT4c671506-2930-414c-a40b-8bf57ded5924:896117tmortontmorton0http://forums.asp.net/thread/896117.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=55&PostID=896117Thank you to <a href="/user/Profile.aspx?UserID=409096">imagemaker</a> for pointing out <a href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;321266">KB article 321266</a>, which contains the list of reserved words for Microsoft Jet 4.0.<br /> <br /> If you see an inexplicable "syntax error" message when trying to execute a SQL statement, a reserved word is the first place to look.&nbsp; 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.<br /> <br /> Password and User are two reserved words that seem to be frequently used as column names.<br /> <br /> <br /> <br />