I am currently using VBA to build two queries with where clauses that query linked MS SQL Server database tables. The process does not take terribly long to run (maybe 8 - 10 seconds) but it freezes the UI.
Would performance and/or query time be improved if incrementally throughout the day I made local copies of these linked SQL Tables then ran the VBA syntax against the local database tables?