Trying to create a heterogeneous query to two Access databases. I can drag a table from one Access database, however, I'm unable to drag a second table from a different Access Database into the query. If I double-click on the table this results in the message: 'Heterogeneous queries can only connect to one Access file at a time'. Will this be addressed in a future version of Toad for Data Analysis?
This is a limitation of the Jet DB Engine, which is the utility we are using to perform heterogeneous queries.
We do not have an alternative to the Jet DB Engine at this time, so there is no way to enhance the product to allow heterogeneous queries against multiple Access connections.