DAO Object
 
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
dbUseJet
The Recordset is connected to the Microsoft Access database engine.
dbUseODBC
The Recordset is connected to an ODBC data source.