Re: HELP!! ACCESS ODBC ORACLE
Date: Sun, 22 Jan 1995 22:26:42 GMT
Message-ID: <1995Jan22.222642.24632_at_cti.wnc.nedlloyd.nl>
Alay (aldesai_at_caip.rutgers.edu) wrote:
: HI,
: I have a problem in MS-ACCESS. The setting is the following:
: I have an application developed in ms-access, which has tables attached to
: a database in Oracle 7. I am using ODBC (which comes with access 2.0) and
: am using Chameleon as my TCP-IP network interface.
Hi I'm not sure but might it be that in case the two tables are fully
retrieved into Access and that the actual join is being done in Access?
While maybe while having one table in access the program will one by one
get the record from Oracle.
In that case you may try to create a view on the Oracle database where
the two tables are joined and from access you select from the view.
Good luck. Pls. let me know whether it worked. Received on Sun Jan 22 1995 - 23:26:42 CET