Access 2013: Use a make table query for faster report loads
Posted on 2014-09-12
Have a legacy database am modernizing using a web database. In testing, the desktop reports were running slow. But they also run slow, when the data is local. Just running that much slower, now.
Took apart the original reports until I found the culprit. There are three sub-reports in the main report and once I removed them, report runs like lightning. So the root cause to speed is the sub-report design, not the new web back end.
Found that make table queries are a much faster way of presenting data in sub-reports and very true. Now that we have this method, the question is: How to elegantly update the new local table, when running the report?