我要用VB代码更新 access里的数据,但系统提示“当前记录集不支持更新。这可能是提供程序的限制,也可能是选定锁定类型的限制”,代码如下
‘
’
‘
Dim cn As New ADODB.Connection, rs1 As New ADODB.Recordset, sql As String Private Sub Command5_Click()
cn.Open "provider=microsoft.jet.oledb.4.0;data source=C:\Program Files\Microsoft Visual Studio\VB98\danzhuangli.mdb"
sql = "basicli where 编号='1'"
rs1.Open sql, cn
rs1.Fields("桩径") = Text1.Text
rs1.Update
end sub
问题是想在一个danzhuangli.mdb里的basicli表里更新数据,比如更新里面的“桩径”列为 Text1.Text内容,但出现如上错误,请各位大侠指教啊~在线等~谢谢!!!!!
‘
’
‘
Dim cn As New ADODB.Connection, rs1 As New ADODB.Recordset, sql As String Private Sub Command5_Click()
cn.Open "provider=microsoft.jet.oledb.4.0;data source=C:\Program Files\Microsoft Visual Studio\VB98\danzhuangli.mdb"
sql = "basicli where 编号='1'"
rs1.Open sql, cn
rs1.Fields("桩径") = Text1.Text
rs1.Update
end sub
问题是想在一个danzhuangli.mdb里的basicli表里更新数据,比如更新里面的“桩径”列为 Text1.Text内容,但出现如上错误,请各位大侠指教啊~在线等~谢谢!!!!!
改为sql="select *from basicli where 编号='1'"
rs1.Open sql, cn 这句后面有可选参数,比如adOpenKeyset
cn.Open "provider=microsoft.jet.oledb.4.0;data source=C:\Program Files\Microsoft Visual Studio\VB98\danzhuangli.mdb;Persist Security Info=False"
不知对不对
cn.CursorLocation = adUseClient
看看行不?