An object variable that represents an existing object from which you want to create the new Recordset.
A String specifying the source of the records for the new Recordset. The source can be a table name, a query name, or an SQL statement that returns records. For table-type Recordset objects in Microsoft Jet databases, the source can only be a table name.
Optional. A constant that indicates the type of Recordset to open, as specified in Settings.
Optional. A combination of constants that specify characteristics of the new Recordset, as listed in Settings.
Optional. A constant that determines the locking for the Recordset, as specified in Settings.
Proposed as answer bySara_111Wednesday, October 06, 2010 6:52 PM