用 ADO 也同樣可以使用 RecordCount和AbsoultePosition,例如:Private Sub Command1_Click() Dim cnADO as New ADODB.Connection Dim rsADO as new ADODB.Recordset cnADO.CursorLocation = adUseClient cnADO.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\Nwind.mdb"
rsADO.Open "Select * From Orders",cnADO
MsgBox "共有" & rsADO.RecordCount & "條紀錄" MsgBox "當前位置是" & rsADO.AbsoultePosition End Sub
Dim cnADO as New ADODB.Connection
Dim rsADO as new ADODB.Recordset cnADO.CursorLocation = adUseClient
cnADO.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\Nwind.mdb"
rsADO.Open "Select * From Orders",cnADO
MsgBox "共有" & rsADO.RecordCount & "條紀錄"
MsgBox "當前位置是" & rsADO.AbsoultePosition
End Sub