Differences between DAO.Recordset, DAO.Recordsets, DAO.Recordset2

Can someone explain the differences between DAO.Recordset , DAO.Recordsets and DAO.Recordset2 in MS Access 2007? The record set is mainly used ... Give an example to make it more clear. I found some links from the help option, but I do not understand its process ...

+7
source share
1 answer

DAO.Recordset is an object that represents records in the base table or records that result from a query. Read more about the DAO.Recordset here .

DAO.Recordset2 also an object that represents records in the base table or records that result from a query. It has all the properties and methods of the DAO.Recordset object, as well as the additional .ParentRecordset property to support multi-valued fields. Read more about the DAO.Recordset2 object here .

DAO.Recordsets is a collection of all open DAO.Recordset and DAO.Recordset2 . Read more about the DAO.Recordsets collection here .

+15
source

All Articles