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

In article <30FC4D07.7707_at_froglit.scitele.com>, David Lambert <dlambert_at_froglit.scitele.com> says:
>
>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
>
>I was able to eliminate a "query too complex" error by upgrading
>to the jet 2.5 engine (MSAJT200.DLL). I was not using ODBC, do
>I can't guarantee your results.
>
>

Try creating a view on the database which is composed of the ten table select.

Then in Access select from the view. It has worked for us...

Cheers
Ian.

   /\/\     :  Ian Leeson
  / / /\    :  Information Technologist
 / / /  \   :  BHP Information Technology, Newcastle
/ / / /\ \  :  Selwyn Street, Port Waratah, NSW, 2304
\ \/ / / /  :  Phone    +61-49-40-2128
 \  / / /   :  E-mail Leeson.Ian.IS_at_bhp.com.au
  \/\/\/    :