我用VB6+ACCESS2000,我的目的是,在数据保存时,检查ACCESS表dvb(仅有一个记录)的wtdh字段值,现在问题是:当网络上其他用户修改了该字段值后,我检测到的有时是已改过的值,但有时竟然是原来的值,而直接打开数据库,则都是已改过的值,我的检测代码很简单是:Private rstwtzj As New ADODB.Recordset
With rstwtzj
Set .ActiveConnection = cnncl
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
.Open "select * from dvb "
mdh = !wtdh 'mdh变量就是我检测的值
.Close
End with
With rstwtzj
Set .ActiveConnection = cnncl
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
.Open "select * from dvb "
mdh = !wtdh 'mdh变量就是我检测的值
.Close
End with
.LockType = adLockOptimistic
.CursorLocation = adUseServer.CursorType = adOpenDynamicAccess的确不好办,不象SQLServer
With rstwtzj
dim conn as adodc.connection
set conn=new adodc.connection
conn.open cnnc1
Set .ActiveConnection = conn
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
.Open "select * from dvb "
mdh = !wtdh 'mdh变量就是我检测的值
.Close
conn.close
End with