title: Building Queries Using Access and Sql Database
body: <p>I am working in a company where we have hundreds of tables and queries in MS Access and several tables in our SQL Server. Sometimes we need to combine results from both databases. </p>
  
  <p>When we try to do it by linking our SQL tables to MS Access using <code>ODBC connection</code>, the results return very slow that causes our clients to complain. So other than non-ODBC connection property here is what I am looking for;</p>
  
  <ul>
  <li>Being able to build a query using <code>Sql DB</code> and <code>Access DB</code> visually by dragging and dropping tables.</li>
  <li>Being able to save these queries and re-run them using C#</li>
  <li>Being able to use sub-queries (query in another query)</li>
  </ul>
  
  <p>My question is if there is any kind of application or API (paid or unpaid) that supports all these terms? Or is it possible to build such a thing?</p>