title: How to use a Query in another DB as a Form's RecordSource?
body: <p>I'm trying to split a database into two pieces -- a backend that updates automatically, and a front-end that allows searching and adding/editing comments.  The data in the source database is pulled together from multiple tables into a pair of queries, and I want to use these queries as the source of the current database.  </p>
  
  <p>Access 2007 supports splitting a database into multiple pieces, but not in the way I'm looking for.  It keeps the tables in the source database and puts all the forms, queries, reports, and macros into the new database.  The tables and queries are already in the back-end, and this new database should just provide a good GUI to the end-user.</p>
  
  <p>Access 2007 also supports linked tables, but these can only use a table as a source, not a query object.</p>
  
  <p>I was thinking that the best way to do this would be to do a SQL query along the lines of</p>
  
  <pre><code>SELECT * FROM SourceQuery IN "C:\Path\To\ExternalDB.accdb";
  </code></pre>
  
  <p>Is what I'm working towards even possible, and would this be the best way to do it?  </p>
  
  <p>Since its still relatively early in the project, rearchitecting the database isn't out of the question, but is something I'd prefer to avoid.</p>