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 see if it needs to do anything.The problem ...

There are several ways to count the records in a form’s recordset. In fact, Access forms display the record count by default. For many, this built-in feature is more than adequate. However ...