I agree with E-Link because:

If u open a recordset without a where clause then the entire table is open thus increasing load.

Secondly, the filter method takes quite some time.