Creating a Recordset Using the ActiveConnection Property : Recordset Open « Access « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Access
3. Recordset Open

Creating a Recordset Using the ActiveConnection Property

 
Sub CreateRecordset2()
    Dim rst As ADODB.Recordset
    Set rst = New ADODB.Recordset

    rst.ActiveConnection = CurrentProject.Connection

    rst.Open "Select * From Employees"
    Debug.Print rst.GetString

    rst.Close
    Set rst = Nothing
End Sub

 

Related examples in the same category