Controlling disaggregation of JOIN query against linked (oracle) tables

MS Access seems to have its own logic for disaggregating a multi-table JOIN against linked (Oracle) tables. Sometimes it sends the entire JOIN to the Oracle database to have the JOIN performed on the Oracle side, sometimes it disaggregates the JOIN query into multiple single-table queries to retrieve individual table rows and then perform the JOIN operation locally on MS Access. I have not been able to detect any regularity or rules for this behaviour.
Is there any way of controlling MS Access behaviour in how it sends JOIN queries on linked tables to the remote database? Received on Tue Oct 30 2001 - 18:31:35 CET