Re: Linking tables from Oracle to MS Access
Date: 8 Nov 2001 03:19:36 -0800
Message-ID: <aeb3790f.0111080319.59812472_at_posting.google.com>
Hello,
there is no way to disable it in MS_access, once you start it MS-access lanche a ton of stupid query's on your database, when you have multiple user who start access at the same time: don't worry that your performance is NULL !
why don't you use crystal reports, or cognos.
Really: MS-access is a very bad choice !!!! put a bomb on it ! and use a good report writer
Erik.
Oracle DBA consultant.
rhairgroveNoSpam_at_Pleasebigfoot.com (Bob Hairgrove) wrote in message news:<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 Thu Nov 08 2001 - 12:19:36 CET