Recordset.Type property (DAO)
Applies to: Access 2013, Office 2013
Sets or returns a value that indicates the operational type or data type of an object. Read-only Integer.
Syntax
expression .Type
expression A variable that represents a Recordset object.
Remarks
For a Recordset object, the possible settings and return values are as follows.
Constant |
Recordset type |
---|---|
dbOpenTable |
Table (Microsoft Access workspaces only) |
dbOpenDynamic |
Dynamic (ODBCDirect workspaces only) NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. |
dbOpenDynaset |
Dynaset |
dbOpenSnapshot |
Snapshot |
dbOpenForwardOnly |
Forward-only |