The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and ...

i want to check an ado recordset to see if it needs updating. i'm using the adLockBatchOptimistic lock type if it matters.<BR><BR>i have no problem checking the EditMode property (e.g. if ...

I'm trying to write a program that spends most of its time in a wait state. However, it needs to check the database regularly (every minute) to check to ...

The Count() expression will also accommodate a filtered recordset, as shown below. In this case, there are 13 records in the filtered recordset. In both cases, the Count() function works fine.