Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim SqlStr as string cn.open "provider=Microsoft.Jet.oledb.4.0;" & "data source=" & App.Path & "\Data\Data.mdb" 'App.Path & "\Data\Data.mdb" 是你数据库所在的路径和文件名 '假设你存放ABC这些属性的表名为TEST SqlStr = "selet * from TEST where A ='" & A1 & "'" With rs .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open SqlStr, cn Select Case .RecordCount Case 0 '说明不存在主键A值为A1的记录 '给出出错信息 Case 1 '说明存在唯一主键A值为A1的记录 .Fields(2) = text3 'text3的值即为C2,fields(2)即为C字段 .Update Case Else '说明存在多个主键A值为A1的记录
Dim rs As New ADODB.Recordset
Dim SqlStr as string
cn.open "provider=Microsoft.Jet.oledb.4.0;" & "data source=" & App.Path & "\Data\Data.mdb"
'App.Path & "\Data\Data.mdb" 是你数据库所在的路径和文件名
'假设你存放ABC这些属性的表名为TEST
SqlStr = "selet * from TEST where A ='" & A1 & "'"
With rs
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open SqlStr, cn
Select Case .RecordCount
Case 0 '说明不存在主键A值为A1的记录
'给出出错信息
Case 1 '说明存在唯一主键A值为A1的记录
.Fields(2) = text3 'text3的值即为C2,fields(2)即为C字段
.Update
Case Else '说明存在多个主键A值为A1的记录
End Select
.Close
End With
cn.Close