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 ...

</pre><BR><BR>However, this is not sorting my recordset at all, and that is proving to be troublesome. Is there some easier way to do this, or is there something missing here in terms of ...

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 ...

A disconnected recordset (DRS) is an ADO record that resides in memory. A DRS is completely disconnected from its original data source and you can create one "on demand" with relative ease.

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.