我采用如下方式访问数据库,请问怎样才能同一时间只能让一个人修改同一条数据呢,如果另外的人企图修改正被人修改的据数则不允许,请高手赐教!
adoConn.Open "provider=microsoft.jet.oledb.4.0;" & _
"Data source=" & App.Path & "\Main.mdb;" & _
"jet oledb:database password=xxxxxxxxx"
With ADODC1
.ConnectionString = adoConn
.CommandType = adCmdText
.RecordSource = strSQL
.Refresh
End With
adoConn.Open "provider=microsoft.jet.oledb.4.0;" & _
"Data source=" & App.Path & "\Main.mdb;" & _
"jet oledb:database password=xxxxxxxxx"
With ADODC1
.ConnectionString = adoConn
.CommandType = adCmdText
.RecordSource = strSQL
.Refresh
End With
當有人要去操作這條記錄時就檢查它的NOWUSER