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