Can anybody explain the differences between DAO.Recordset, DAO.Recordsets, and DAO.Recordset2 in MS Access 2007? Basically recordset is used....Give an example so that its more clear. I found some references from Help Option but I am not clear with its process...
Asked
Active
Viewed 6,956 times
11
HansUp
- 95,961
- 11
- 77
- 135
1 Answers
20
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.
Gord Thompson
- 116,920
- 32
- 215
- 418
Santosh
- 12,175
- 4
- 41
- 72