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?

Thanks,

David

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
based operation.

--

Terry Kreft


"David" <david (AT) adrenasys (DOT) com> wrote

Terry Kreft wrote:
My experience when working against ODBC links to SQL Server that FIND is so
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