为什么不能添加数据?
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/temp/testinsert.asp, line 17
testinsert.asp代码如下:
<!--#include file="adovbs.inc" -->
<%
data_source ="Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" & Server.MapPath("test.mdb")
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
Set rs = Server.CreateObject("ADODB.Recordset")
rs.cursorlocation=3
rs.Open "table1", con, 3,3
rs.AddNew
rs("ID")="org"
rs("TEXT")="goodfriend"
rs.Update
response.write "insert data successfully!"
rs.close
con.Close
Set con = Nothing
%>