Access 2007 & "Password" Reserved?


Author
Message
Crones
Crones
StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)
Group: Forum Members
Posts: 35, Visits: 345
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....

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search