Access vba current recordset does not support updating


The most reliable check uses a simple If statement before executing a move method: The BOF property returns True when the current position is before the first record.Similarly, EOF returns True when the current position is just beyond the last record.Moving through the records in a Recordset is a common task, but doing so comes with a few hazards.Using any move method will generate an error if the Recordset object is empty.



Whether using Record Count to check for the existence of records or to count records, you must remember the differences between DAO and ADO: Tip: Don't use Move Last with a large Recordset to check for an empty Recordset. If Record Count returns 1, you know the Recordset isn't empty.Always make sure you include a Move Next method when you mean to cycle through a set of records.Failing to move in any type of looping structure can have the same result — this isn't just a Do loop consideration.If both properties are True simultaneously, the Recordset is empty.

Tip: Including the Not operator is a matter of efficiency.

In fact, DAO and ADO use the Recordset object to represent a multivalue field.