I believe that the JET Database Engine (on which Access is based) always
performs joins, order bys, etc... locally. I believe though that it only
grabs a certain number of rows at a time from the actual table.
- Greg
-----Original Message-----
From: Mihai Gheorghiu [mailto:tanhq@bigplanet.com]
Sent: Thursday, June 01, 2000 2:49 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] ODBC driver
A previous message mentioned that MSAccess performs a join locally when
accessing a postgres database via the ODBC drivers (link files).
Does that mean that it sends the entire tables from the postgres server to
the Win computer and the query is actually performed by MSAccess?
Thanks,
Mihai Gheorghiu