title: Unable to query from a different DB
body: <p>I have two identical databases, one containing data related to year1 and the other containing data related to year2.
  in both databases I have a table which joins product data and customer data into one query called "Data_Details".
  Now if I run the following from within the same database</p>
  
  <pre><code>Select * FROM Data_Details;
  </code></pre>
  
  <p>Everything works as expected, but if I run it from the other Db</p>
  
  <pre><code>SELECT *
  FROM Data_Details IN 'path_to_my_db/Database.accdb';
  </code></pre>
  
  <p>I get a 'wrong type' error message.
  I have tried removing fields from the query, to check where the issue was lying but I realized that I am able to retrieve data from the other db as long as the Data_Details query is a simple SELECT query;as soon as I add a Join to it, no matter what, I am no more able to retrieve anything from it from another DB while it works perfectly if I run it from the same DB.</p>