forward-only – type Recordset

A Recordset object in which records can be searched only from beginning to end; the current record position can't be moved back to the first record. Forward-only – type recordsets reduce processing overhead on remote databases. For example, you can use a forward-only – type Recordset on a linked remote table to quickly process data in one pass, such as when you’re building a customized report.