InstantForum.NET v4.1.4StrataFrame Forumhttp://forum.strataframe.net/forum@strataframe.netThu, 28 Aug 2008 14:43:26 GMT20http://forum.strataframe.net/Topic15112-6-1.aspxYes, it might very well be a reserved word. 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). If it still gives you an error, then try putting [] around the "password" so it looks like [Password] in the command. 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 GMTBen Chasehttp://forum.strataframe.net/Topic15112-6-1.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>Sat, 22 Mar 2008 17:47:44 GMTCrones