jdasilva (5/9/2014)
Have not started to play with doing this, but looking it over, it still seems like the work is being done from access, which is what is causing the slowdown. I was wondering if I had the full query (all offices) done on the SQL server, then used a query on access to filter for just the office number, would that be quicker? That way I would not have to pass anything.
Yes; send your requests to SQL. Let it do the heavy lifting.
This article is insightful; I don't want to speak to the performance pitfalls of recent versions of Access because my knowledge is out-of-date and I don't know if it's relevant anymore.