asp不能更新ACCESS
<%
dbpath = "data.mdb "
connstr = "driver={Microsoft Access Driver (*.mdb)};pwd=hardwarewto;dbq= " & Server.MapPath( " "&dbpath& " ")

Set conn = Server.CreateObject( "ADODB.Connection ")
conn.open connstr

set res=Server.CreateObject( "ADODB.Recordset ")
sqlcmd= "select * from admin "
res.Open sqlcmd,conn,1,3

res.addnew
res( "admin ")= "test "
res.update
set res = nothing
response.end
%>
可是ACCESS并没有增加一条记录？哪里没写好呢？

[解决办法]
改成这样试试：

dbpath = "data.mdb "
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath(dbpath)

Set conn = Server.CreateObject( "ADODB.Connection ")
conn.open connstr

[解决办法]
res.Open sqlcmd,conn,1,3
改为
rec.open sqlcmd,conn,3,2