Easy SQL Question

[Ryan Smith]

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','1234567 890','t***@test.com','TEST')

Sincerely,
Ryan Smith

[TJS]

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

"Ryan Smith" <Ry*******@discussions.microsoft.com> wrote in message
news:F8**********************************@microsof t.com...

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','1234567 890','t***@test.com','TEST')

Sincerely,
Ryan Smith

[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.

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx

"Ryan Smith" <Ry*******@discussions.microsoft.com> wrote in message
news:F8**********************************@microsof t.com...

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','1234567 890','t***@test.com','TEST')

Sincerely,
Ryan Smith

[Chris]

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

"Ryan Smith" wrote:

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','1234567 890','t***@test.com','TEST')

Sincerely,
Ryan Smith

[Binoj Antony]

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' )