Yes, 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.

Is the term "Password" a reserved word in an Access 2007 Database?

I keep getting an Syntax Error in INSERT and on UPDATE commands when I have a field named "Password".

This was driving me nuts because looking at the DEBUG output of the command, it is valid...



INSERT INTO Users (Username, Password, DisplayName) VALUES (?, ?, ?);



Param0:    'Testing' [DbType: String | Size: 7 | Direction: Input | SourceColumn: Username | SourceVersion: Current]

Param1:    'Testing' [DbType: String | Size: 7 | Direction: Input | SourceColumn: Password | SourceVersion: Current]

Param2:    'DisplayName' [DbType: String | Size: 11 | Direction: Input | SourceColumn: DisplayName | SourceVersion: Current]



I don't recall having this issue in the past....