Stumped - what is wrong with this insert statement?

[PatM]

INSERT INTO users (fullname,username,password,role) VALUES ('Sean Guy','sguy','password',2)

Seems pretty simple. I tried the "2" with single quotes as well with no luck. I even checked letter case to make sure everything matches

 

[jmcilhinney]

"Password" is a reserved word in Jet/ACE SQL, so you must escape it when using it as an identifier. You do that by wrapping it in brackets, just as you do in VB.

 

[PatM]

I had no clue that was a problem. Access 2003 let me name the column that without complaint too.

Oh well, now to figure out how to parameterize the same same insert.

Salamat po!

 

[jmcilhinney]

You can name tables and columns whatever you want. It's only in SQL code that it becomes a problem, because reserved words, spaces and other special characters will cause syntax errors if not escaped. It is better to avoid such names altogether. Given that passwords should be hashed in real systems, such columns can be named PasswordHash and there's no issue.