SQL Query using ODBC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 somewhere else).

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

--
HTH
Van T. Dinh
MVP (Access)


wheeel_o said:
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
Click to expand...
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
Click to expand...
in access? Views in Postgres? or maybe VB in Access?
 
Back
Top