Easy SQL Question - Newbe

[Guest]

I am trying to insert data into an access 2k3 db and receive an invalid
syntax message.

The statement is:

INSERT INTO Users (UsrName,Username,Password,UsrStatus,UsrType) VALUES
('TESTNAME','TESTUSR','TESTPASS',0,0)

DB looks like the following: (ID=Autonumber)(Username,Password,UsrName =
String)(UsrType,UsrStatus=Number)

ID Username Password UsrType UsrStatus UsrName
1 asdf asdf 0 0 test test
2 test test 1 0 testing testing

Any help is greatly appreciated as this is driving me crazy.

Ryan

 

[Bob Lehmann]

'Password' is reserved. Rename the column (better choice) or enclose it in
square brackets (bad choice) - [Password].

Bob Lehmann