Question

ASP记录集（ACCESS数据库)无法更新，如何设置记录集可读写

<%Dim Recordset1Dim Recordset1_cmdDim Recordset1_numRowsSet Recordset1_cmd = Server.CreateObject ("ADODB.Command")Recordset1_cmd.ActiveConnection = MM_cnn2_STRINGRecordset1_cmd.CommandText = "SELECT [count] FROM dbcount" Recordset1_cmd.Prepared = trueSet Recordset1 = Recordset1_cmd.ExecuteRecordset1_numRows = 0%><% Recordset1.Fields.Item("count").Value=Recordset1.Fields.Item("count").Value+1 Recordset1.update %>

Answer 1

ACCESS在IIS里面最常见的就是权限问题.
把IIS目录设置成有写操作的权限,
Access就可以更新数据了.

Answer 2

Set Recordset1 = Recordset1_cmd.Execute
这样得到的recordset是不能更新的，它是只读的。 你必须使用rs.open sql,conn,1,3得到的记录集才是可更新的！

Answer 3

<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from [count] ",conn,1,3
%>