Lynx101 wrote:
Background:
I have recently started to look at converting an access backend into
an SQL backend.
Question:
By default, when using a query in access does the SQL server only send
the records requested from the query OR does SQL still send everything
and the filtering is done by Access?
"Still"? That suggests you think Access/Jet sends everything. Access/Jet does
not and neither will a SQL Server back end.
If the latter, how to I get SQL to do the hard work and not access?
A standard Access query against an ODBC linked table will usually send most of
the request to the server, but the amount of work done on the server varies
depending on the structure of the query. To guarantee 100% work by the server
you use a passthrough query. Only problem is that passthrough queries are
always read-only.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com