title: Storing queries on backend access database
body: <p>I have built a split ms access 2013 database for a handful of users to share over our office LAN. I have been developing the front end forms and code and distributing by releasing new versions of the front end. </p>
  
  <p>I would now like to build a reports menu but I would like to store the queries on the back end so I can make changes without releasing a new front-end version every time I update or add a report. </p>
  
  <p>Is there a way to call a report or query in vba that is stored on the back end mdb? Would there by any significant performance degradation? If I understand how split access databases work , the queries are still processed on the local machine so it doesn't seem like it would make a difference. I have searched around the web but I have not found any questions on the topic. This leads to be believe I am on the wrong track. Thoughts?</p>
  
  <p>Matt</p>