When you first Open Recordset(), Access grabs the first record, and keeps processing your code while the others load.So, if you test Record Count immediately after you Open Recordset, you typically get 0 (if there are no records), or 1 (if there are any, regardless of how many will load.) This does not apply to recordsets of type db Open Table type (the default for local tables.) If you need to know the Record Count, use the Move Last method first.When you Open Recordset() on a local table, it defaults to a Table type (db Open Table.) The Table type has different methods (e.g.
Your program then fails, or returns inaccurate results.
The DAO and ADO libraries both have a Recordset object, but with different methods, properties, and options.