Oracle-L: Re: access/oracle

From: <dgoulet_at_vicr.com>
Date: Sun, 02 Feb 2003 16:38:36 -0800
Message-ID: <F001.00541951.20030202163836@fatcity.com>

Bill,
I have to live with people who want to usc Access too. I agree wfth you it is a pain in the a--. Our solution, with damagement's agreement, is to only do what is possible. I think that in your situation you'll have to do likewise. The problem being Access's local tables. What may help is if they link the tables & apply the appropriate limits on each.

Dick Goulet
becker.bill_at_marshfieldclinic.org wrote on 1/31/03 2:24 pm:

Hello,

We are stuck with a group of users who insist on using MS access 2K 9.0 on a Win2K workstation as an adhoc query front end to an Oracle 8.1.7.4 db on Sun.

The problem is that their queries run OK when executed from sqlplus directly against Oracle, but are terrible when executed from access. This is because access has tables linked to the oracle tables, and access insists on downloading all the data, performing the joins and where clause filters on the local workstation.

I don't know much about access, and don't want to; however, this has been dumped on us, so I am hoping that someone has experienced the same problem and found a solution. No, we can't dump access, and use something different; for reasons beyond our control (management), we have to make this work.

I think the solution is to somehow force the query to be processed on the Oracle machine, and return only the result set. We have tried the access "passthrough" option, but I believe that fails due to the newer ansi syntax used by access. (OUTER JOIN, INNER JOIN, etc.) The users insist on using access's gui query generator.

Has anyone found a solution to this? Is there a good whitepaper somewhere like, "Using Access as a Front-End Query Tool to Oracle?" (I will search google)

Thanks to all who have read this far,
More thanks to any responders,
Most thanks for any helpful advice

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: becker.bill_at_marshfieldclinic.org

Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services

--------------------------------------------------------------------- To REMOVE

yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Feb 02 2003 - 18:38:36 CST