adCmdTable - A SQL query is generated to return all rows from the table named in the source. : Recordset Open « Access « VBA / Excel / Access / Word

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

adCmdTable - A SQL query is generated to return all rows from the table named in the source.

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

    rst.ActiveConnection = CurrentProject.Connection
    rst.CursorType = adOpenStatic
    rst.LockType = adLockOptimistic

    rst.Open "Select * from Employees", _
        Options:=adCmdTable

    rst("City") = "Village"
    rst.Update
    Debug.Print rst("City")

    rst.Close
    Set rst = Nothing
End Sub

 

Related examples in the same category