Dynaset-Type Recordset Object Example (MDB)

The following example creates a dynaset-type Recordset object, then checks the Updatable property of the Recordset object:

Sub RecentHires()
    Dim dbs As Database, rst As Recordset
    Dim strSQL As String
    
    ' Return reference to current database.
    Set dbs = CurrentDb
    ' Open recordset on Employees table.
    Set rst = dbs.OpenRecordset("Employees", dbOpenDynaset)
    Debug.Print rst.Updatable
    rst.Close
    Set dbs = Nothing
End Sub