hi...i keep getting this error...i KNOW why im getting, i just dont know any way around it...im using session variabes from a form and they are being inserted into an access db...the problem is that my database has one extra field which is my primary key "ID" (autonumber)...it works fine when i take it out, but then im left without a primary key...my statement looks like this...

sSQL = "INSERT into appTest_tbl values ('" & _
(Session.SessionID) & "','" & Session("lastname") & "','" & Session("firstname") & "','" & Session("midname") & "','" & Session("presentstreet") & "')"

because im adding 5 fields to a database which has 6 openings it gives me this error...any ideas? thanks for your time...

try specifying your column values eg...

sSQL = "INSERT into appTest_tbl (col2, clo3, col4, col5, col6) values ('" & _
(Session.SessionID) & "','" & Session("lastname") & "','" & Session("firstname") & "','" & Session("midname") & "','" & Session("presentstreet") & "')"