What is the comparison of server sizing in terms of RAM/CPU/storage type et between the access and SQL Server. Trying running the query directly on the SQL Server and Access backend server to get the actual query execution time.