'Query is too complex' error while using MS Access ODBC driver

[erramesh74]

Hi,

We are using Microsoft Access ODBC driver to retrieve data from a MS Access database. A query issued by Oracle produces 'Query is too complex' error. The query length is more than 2048 characters. The query is constructed by the Oracle Heterogeneous Services which uses the Microsoft ODBC connection to retrieve data from the MDB. The error looks like this :
[Microsoft][ODBC Microsoft Access Driver] Query is too complex. (SQL State: S1000; SQL Code: -3071)

The configuration we are using is :
OS : Windows 2000
MS Access 2000
Microsoft ODBC Driver for Access Version 4.00.6019.00

Can you give me some tips/advice to make the ODBC driver read more than 2048 character length query ?

Thanks & Regards,

Ramesh.