I have an app that runs several queries depending on user input. The data
source is an Access database that's right at the 2GB limit. I stored
numerous queries in the database to cover all the possible user selections
from the Excel app. I'd read that stored queries are a bit faster than just
sending the SQL script. Database resides on a LAN

Average time on these varies from 2 1/2 mins to 5 mins. From listening to
users (especially my boss) we need to improve this time.

I've tried every way I could think of to run this and nothing shortens the
time. 99.5% of the wait is while opening the recordsets.

My question:

Due to the size of this db (and its only one table but with 1.5M records)
would moving this to a SQL table and querying off of that speed this up? I
do some other stuff against our main SQL tables and they are painfully slow,
but that's with lots of joins and far more records. This would just be the
one table.