Re: Linking tables from Oracle to MS Access

From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Sun, 04 Nov 2001 02:48:00 GMT
Message-ID: <3be45270.40261533_at_news.webshuttle.ch>

On 30 Oct 2001 09:25:48 -0800, claus.gehner_at_wwireless.com (Claus Gehner) wrote:

>We are using MS Access as a reporting front-end for Oracle databases.
>We are using the Oracle ODBS driver (8.1.7).
>When linking to an Oracle table (or tables), MS Access sends off a
>fairly involved query to the Oracle data dictionary to identify any
>constraints, indexes, etc. associated with the table(s) being linked.
>Is there any way to turn this off -- and rely on manually defining the
>"Relationships" among the tables ?

Try defining the Access queries which feed the reports as passthrough queries (using Oracle SQL syntax). Received on Sun Nov 04 2001 - 03:48:00 CET

This message: [ Message body ]
Next message: Bruce C. Baker: "Re: RDBMS"
Previous message: Jim Kennedy: "Re: sql limitation?"
Next in thread: Erik: "Re: Linking tables from Oracle to MS Access"
Reply: Erik: "Re: Linking tables from Oracle to MS Access"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message