|
发表于 2009-4-10 16:52:30
|
显示全部楼层
Option Explicit
Private Sub Command1_Click()
Dim objCn As New Connection
Dim objRs As New Recordset
objCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;Persist Security Info=False;user id=admin;Jet OLEDB:Database Password="
objCn.Open
objRs.Open "select * from tab", objCn, adOpenKeyset, adLockPessimistic
Dim i As Integer
For i = 0 To 20000
objRs.AddNew
objRs.Fields("str").Value = i
objRs.Update
Next
MsgBox "写入成功", vbInformation
End Sub
Private Sub Command2_Click()
Dim objCn As New Connection
Dim objRs As New Recordset
objCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;Persist Security Info=False;user id=admin;Jet OLEDB:Database Password="
objCn.Open
objRs.Open "select * from tab", objCn, adOpenKeyset, adLockPessimistic
Dim i As Integer
For i = 0 To 20000
If objRs.Fields("str").Value <> i Then
MsgBox "校验失败", vbInformation
Exit Sub
End If
objRs.MoveNext
Next
MsgBox "校验成功", vbInformation
End Sub
楼主,我用上面的代码,写入,校验都成功的呢。校验的时间明显比写入的时间短,呵呵 |
|