insert with a autonumber row

var SQLString = "INSERT INTO table VALUES( '' ,'" + Request.Form("name") + "','"
+ strAlpha + "','', '"
+ Request.Form("email") + "', '"
+ Request.Form("userid") + "')";

dbConnection.Execute(SQLString);


This is jscript inserting into access2000. My table looks like this:

id (autonumber)
name
date
email
userid

Its the first field that causing my problems, I get a data type mismatch error. How do I insert with an auto incremented field?!

its an autonumber field. you don't need to insert anything in that field. take the leading comma out, and just insert the four items, Name, date, email, and userID.

try this. this might resolve your issue

var SQLString = "INSERT INTO table (name, date, email, userid) VALUES( '" & Request.Form("name") & "', '" & strAlpha & "','', '"
& Request.Form("email") & "', '"
& Request.Form("userid") & "')";