Syntax error in INSERT INTO statement???

[albertlse]

Please download the attachment and unzip it.

I have 4 files:
Starting with "signup.asp" - fill up the registration form. this will forward you to next form.
"signup_process.asp" - process the filled form
"signup_success.asp" - indicate that register successfully
"Database.mdb" - the database file (MS Access 2000 format)

My problem occurs in "signup_process.asp".
The error message found in IE:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/myweb/signup_process.asp, line 31

I look through my code, but found no mistake.

But why still I cannot add the information in the form into the "Database.mdb"?

Please guide me. Thank you.

[Cander]

do a response.write of your insert statement without actually doing anything with it, then carefully read the staement and look for the problem. The problem is in your staement whatever it is.