When using the Filter property, is it true that, for example, if I pulled 

a table into a recordset that the entire table is present in that 

recordset?  I'm just concerned about overhead and wondered if using this 

property is bad when dealing with large tables.



Thanks!

I believe your concern is justified.



No, the whole table isn't pulled into memory, but meta data about it is. Far

better (IMHO) would be to construct an SQL statement that only pulled the

fields, and records, you require into the recordset in the first place.



Cheers

Ken