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.
From: Mihai Gheorghiu [mailto:tanhq(at)bigplanet(dot)com]
Sent: Thursday, June 01, 2000 2:49 PM
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?
pgsql-interfaces by date
|Next:||From: Randall Skelton||Date: 2000-06-01 22:22:22|
|Subject: TCP/IP DB connection for a Macintosh?|
|Previous:||From: Mihai Gheorghiu||Date: 2000-06-01 21:49:00|
|Subject: ODBC driver|