Speed difference in Find and Filter - 09-14-2006 , 11:09 AM
We're using Access 2003 as a front end for a SQL Server database. When
opening a linked table in Access, why is there such a huge speed
difference in Filtering by a value and doing an Edit->Find?
Re: Speed difference in Find and Filter - 09-15-2006 , 09:57 AM
You don't say which you are finding the faster, but I would expect, all
things being equal that a filter would be faster than a find. The reason
being that a filter is a set based operation whereas a find is a cursor
"David" <david (AT) adrenasys (DOT) com> wrote
Re: Speed difference in Find and Filter - 09-15-2006 , 10:09 AM
Terry Kreft wrote:
slow as to be unusable. I assume it pulls the data over so it can be
scanned in Access locally. Filters on the other hand pass perfectly concise
SQL statements to the server and respond very fast.
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com