Re: IN [ODBC with multiple tables

From: MGFoster <me_at_privacy.com>
Date: Mon, 07 Mar 2005 02:59:46 GMT
Message-ID: <CsPWd.3292$cN6.1238@newsread1.news.pas.earthlink.net>

Randy Harris wrote:
> I have been using "IN" to query tables in Oracle from MS Access very
> successfully.
>
> Select Field FROM MyTable IN [ODBC...etc
>
> Works great if there is only one table involved. Anyone know how I can use
> the same technique with multiple tables (and be certain that the join occurs
> at the server).
>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Microsoft recommends that instead of the IN <table> clause you link any tables you want to the Access db file. Then run queries against the linked tables.

You can also run SQL Pass Through (SPT) queries, then all the work will be done on the Oracle server & only the results passed back to Access.

-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQivDrYechKqOuFEgEQLU/QCdF9eXJrBbteh47GQhGuB0k9nrDyIAoNWm
nsoYNJ/0ib2yo6xfCmKdxjVV
=gsnp
-----END PGP SIGNATURE-----

Received on Sun Mar 06 2005 - 20:59:46 CST