VBA Access recordset counting only 1
Posted on 2010-11-30
I've got a problem with a recordset variable that I am using for a loop. The code is as follows:
Set rst = dbs.OpenRecordset("SELECT * FROM LUL_Devices")
Counter = rst.RecordCount
While Counter <> 0....
Counter = Counter - 1
Although the table LUL_Devices has 5,625 records in it, rst.RecordCount is only returning 1, and so the loop is only updating one record. Can anyone advise why only 1 record is being stored in the recordset.
Many thanks in advance.