For snapshots, select just the fields you need instead of all fields

Snapshot-type recordsets are a complete copy of all the data that you've requested. As such, it makes sense to minimize copying data that you don't need, especially Memo and OLE fields from ODBC data sources. If you are using a lot of fields, it probably makes sense to use a dynaset instead.

Tip #4 explains some key differences between dynasets and snapshots, especially with respect to ODBC data.