Easy SQL Question

[Guest]

I'm getting a syntax error on the following SQL Statement. Can anybody see
something wrong here that I can't. All of the data fields are type text and
i'm using Jet 4.0 to connect to an Access 2000 backend.

INSERT INTO
Users(FNAME,LNAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,PHONE,FAX,EMAIL,PASSWORD)
Values ('Suzie','Smith','123 main st','Suite
2108','Orlando','fl','32804','1234567890','1234567890','(e-mail address removed)','TEST')

Sincerely,
Ryan Smith

 

[TJS]

try omitting fields, one at a time, until you find the problem

 

[Robbe Morris [C# MVP]]

Are you sure PASSWORD isn't a reserved word in Access?

If any of your columns are numbers, they don't need ' around the
values.

 

[Guest]

Is your zip column int or number? If so then make '32804' 32804.

 

[Guest]

Copy the below text exacly as is and execute

INSERT INTO Users ( FNAME, LNAME, ADDRESS1, ADDRESS2, CITY, STATE, ZIP,
PHONE, FAX, EMAIL, PASSWORD ) Values ( '1', '1', '1', '1', '1', '1', '1',
'1', '1' ,'1', '1' )