Differences between DAO.Recordset,DAO.Recordsets,DAO.Recordset2
DAO.Recordset is an object that represents the records in a base table or the records that result from running a query. Read more about the DAO.Recordset object here.
DAO.Recordset2 is also an object that represents the records in a base table or the records that result from running a query. It has all of the properties and methods of the DAO.Recordset object, along with an additional .ParentRecordset property to support multi-valued fields. Read more about the DAO.Recordset2 object here.
DAO.Recordsets is the collection of all open DAO.Recordset and DAO.Recordset2 objects. Read more about the DAO.Recordsets collection here.