Take a look at my code. THis is the error the browser gives me:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/ReclaimAmerica.org/test.asp, line 87

Line 87 is flagged with a +++

What is the problem?


sSQL = "INSERT INTO Register(FirstName, LastName, email, userID, address, state, zipcode, phone " & _
"password, userLevel) VALUES ('" & strFirstName & _
"','" & strLastName & "','" & strEmail & "','" & strUserID & "','" & strAddress & "','" & strState & "','" & strZipCode & "','" & strPhone & "','" & strPassword & "',1)"
+++Dconn.Execute sSQL
Dconn.Close
Set Dconn = Nothing