Insert problem in Access 1

[bowettwow]

Please help - I am going crazy. I'm trying to insert a record into an Access database. I get the error:

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/bowettsite/addMember.asp, line 54

Here is my SQL statement:

sqlStatement="INSERT INTO members(Username, Password, Name, Surname, Occupation, Email) VALUES('John', 'Hello', 'Johnny', 'Surname', 'Market Trader', 'someit@someit.someit');"

I can even copy the statement into Microsoft Query and it updates fine!

 

[onpnt]

is the case of the column headings correct _________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[mwolf00]

Name is a keyword... Try this...

sqlStatement="INSERT INTO members(Username, Password, [Name], Surname, Occupation, Email) VALUES('John', 'Hello', 'Johnny', 'Surname', 'Market Trader', 'someit@someit.someit');"

Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
Tek-Tips Best Practices: FAQ183-3179

 

[bowettwow]

Ok - I have an update. It works if I switch my connection string from:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/Site.mdb&quot & ";"

To a DSN pointing at the database. Any ideas whats wrong with the connection string above.

 

[mwolf00]

I've heard that OLEDB is a little persnickety with Access. Did putting [Name] into your query fix it? Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
Tek-Tips Best Practices: FAQ183-3179

 

[bowettwow]

No [name] didn't work.

 

[bowettwow]

Problem solved!!

Needed to be [password]

Cheers all.

 

[onpnt]

there's nothing sparkingly wrong with thte connection string
the ";" is not needed but I do not think that makes a diff
eg:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/Site.mdb&quot _________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[mwolf00]

Damn, I was close! Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
Tek-Tips Best Practices: FAQ183-3179