Current recordset does not support updating in vb6
No matter how experienced you are, it's difficult to commit every little behavior and requirement to memory.Luckily, you can avoid some of the most common mistakes if you just plan for them.ADO is the default object library for Access, but DAO is still available.If you use a DAO Recordset, you must explicitly reference it.However, the possibility means that any Recordset that includes such a field must be able to handle the multiple values.In other words, a Recordset field could actually be another Recordset object.You'll also use them individually when moving through records.Moving beyond the first or last record returns an error.
If you expect the Recordset to contain records most of the time, it's more efficient to include Not in the check.
The condition for ending the loop is never met and the position within the loop never moves.
Always make sure you include a Move Next method when you mean to cycle through a set of records.
Using any move method will generate an error if the Recordset object is empty.
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.