When you first open a Recordset, the current record pointer will point to the first record and the BOF and EOF properties are False.
If there are no records, the BOF and EOF property are True.
For more information, see Record Field Exchange (RFX) and Recordset: Fetching Records in Bulk (ODBC).
A recordset object gives you access to all the selected records.
RFX and Bulk RFX simplify the transfer of data from the data source into your recordset; RFX additionally transfers data from your recordset to the data source.Existing applications that reference the outdated ADOR.Recordset Prog ID will continue to work without recompiling, but new development should reference ADODB. There are four different cursor types defined in ADO: Note To execute a query without using a Command object, pass a query string to the Open method of a Recordset object.You scroll through the multiple selected records using .At the same time, a recordset object represents only one of the selected records, the current record.