Re: MS Access & Oracle ODBC "Query Too Complex" message when more than 10 tables joined

Keith Matthews wrote:
>
> I cannot perform a complex query without the "Query too complex" message
> from Access 2.0.
> I am using v1.11.0.5.0 of the Oracle v7.0 ODBC driver.
> Any ideas please
> Keith Matthews

This is NOT how to use Access as an Oracle front-end.

Access in not 'intelligent' enough for very complex queries. It will attempt to bring back vast amounts of data and process it locally.

Create the query in Oracle as a view or snapshot, i.e. let the server do the work, that's what Oracle is good at.

From Access the query should be 'select * from data_source'.

If you need to use query parameters then store these in a temp Oracle table (username, par1, par2, etc) and include that table in the view definition.

NOTE: If you have more than 10 tables in a query then re-think your data structure. Received on Wed Jan 17 1996 - 00:00:00 CET