Use Table Type Recordsets Instead of Dynaset or Snapshot Types
Table type recordsets are probably the best of all performance boosters. DAO provides three recordset types: dynaset, snapshot, and table. Of these three types, the table recordset type is the