dim AdoCN As New ADODB.Connection
dim rs As New ADODB.Recordset
connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My Documents\blj\MDB\BitSoft.mdb;Mode=Read¦Write;Persist Security Info=False"
AdoCN.open connstr
rs.CursorLocation = adUseClient
sqlstr = "select * from MST_OPERATOR WHERE OperatorID=2"
rs.Open sqlstr, conn, adOpenKeyset, adLockOptimistic
rs("OperatorNO")="0001"
rs("OperatorName")="blj"
rs("Password")="WERW"
rs("Remark")="dfg"
rs.update
rs.close
set adocn=nothing