InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 07 Apr 2026 18:09:00 GMT20http://forum.strataframe.net/FindPost15112.aspxIs the term "Password" a reserved word in an Access 2007 Database?<br> I keep getting an Syntax Error in INSERT and on UPDATE commands when I have a field named "Password".<br> This was driving me nuts because looking at the DEBUG output of the command, it is valid...<br> <br> INSERT INTO Users (Username, Password, DisplayName) VALUES (?, ?, ?);<br> <br> Param0: 'Testing' [DbType: String | Size: 7 | Direction: Input | SourceColumn: Username | SourceVersion: Current]<br> Param1: 'Testing' [DbType: String | Size: 7 | Direction: Input | SourceColumn: Password | SourceVersion: Current]<br> Param2: 'DisplayName' [DbType: String | Size: 11 | Direction: Input | SourceColumn: DisplayName | SourceVersion: Current]<br> <br> I don't recall having this issue in the past....<br>Mon, 24 Mar 2008 08:36:08 GMTCroneshttp://forum.strataframe.net/FindPost15124.aspxYes, it might very well be a reserved word.&nbsp; Try calling that command directly on the database (not through the SF data source) and see if it executes (create a quick little test app to try it out).&nbsp; If it still gives you an error, then try putting [] around the "password" so it looks like [Password] in the command.&nbsp; If that works, then we'll need to modify our data source item to add the quoted identifiers for the field names.Mon, 24 Mar 2008 08:36:08 GMTStrataFrame Team