I receive the following error with my insert query...

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/email_process.asp, line 19

the code in question follows....
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath

Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open strConnectionString

Set blogData = Server.CreateObject("ADODB.Recordset")
strSQL = "INSERT INTO list(Email) VALUES('" & Request.Form("email") & "');"
Response.Write strSQL
blogData.Open strSQL, cnn
blogData.Close
%>

Anyone know why i recieve that error?

Hi there,

Take a look at this FAQ: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=263

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.