Efficient queries with SQL backend

I am using a Postgres backend and Access for my frontend.

When I run a query in access, does the entire table which i am querying get transferred over the network and then get sorted by Access or does the ODBC create a Postgres SELECT command and transfer the output of that SELECT over the network?

To make my queries the most network efficient, should I be using queries in access? Views in Postgres? or maybe VB in Access?

Thanks very much.

Already answered in "microsoft.public.access".

Please do not multi-post. See:

http://www.mvps.org/access/netiquette.htm

--
HTH
Van T. Dinh
MVP (Access)


"wheeel_o" wrote in message
...
I am using a Postgres backend and Access for my frontend.

When I run a query in access, does the entire table which i am querying
get transferred over the network and then get sorted by Access or does the
ODBC create a Postgres SELECT command and transfer the output of that SELECT
over the network?

To make my queries the most network efficient, should I be using queries
in access? Views in Postgres? or maybe VB in Access?

Thanks very much.