adCmdStoredProc - The provider evaluates the source as a stored procedure. : Recordset Open « Access « VBA / Excel / Access / Word

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

adCmdStoredProc - The provider evaluates the source as a stored procedure.

 
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:=adCmdStoredProc

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

    rst.Close
    Set rst = Nothing
End Sub

 

Related examples in the same category