Private Sub Command1_Click()
Dim AdoCn As ADODB.Connection
Dim AdoRst As ADODB.Recordset
Set AdoCn = New ADODB.Connection
Set AdoRst = New ADODB.RecordsetAdoCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Jet OLEDB:Database Persist Security Info=Fals"
AdoCn.Open
AdoRst.CursorLocation = adUseClient
AdoRst.CursorType = adOpenDynamic
AdoRst.LockType = adLockBatchOptimistic
AdoRst.ActiveConnection = AdoCnAdoRst.Open "select * from TestTable"
Debug.Print AdoRst.RecordCountEnd Sub
Dim AdoCn As ADODB.Connection
Dim AdoRst As ADODB.Recordset
Set AdoCn = New ADODB.Connection
Set AdoRst = New ADODB.RecordsetAdoCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Jet OLEDB:Database Persist Security Info=Fals"
AdoCn.Open
AdoRst.CursorLocation = adUseClient
AdoRst.CursorType = adOpenDynamic
AdoRst.LockType = adLockBatchOptimistic
AdoRst.ActiveConnection = AdoCnAdoRst.Open "select * from TestTable"
Debug.Print AdoRst.RecordCountEnd Sub
Provider=AdsDSOObject;Password="",Encrypt Password=False;Data Source=Book1.xls;Location=c:\temp\;Mode=ReadWrite;Bind Flags=0;ADSI Flag=-2147483648