[SQL] How to migrate and process queries (not just tables) in SQL Server instead of Access?

My aging Access 2010 database is quite slow and unstable now. All tables, queries and forms were stored in Access, and it can't handle the load of my department (20+ users). I thought of using SQL Server as a back-end, and migrated the database using Migration Assistant.

Now, my tables are linked and stored in the SQL Server, but when using the forms in Access as front end, the queries take much longer to load than before. (I assume since queries are still executed in Access, plus network connection latency to take data from tables)

Is there an easy/automated way to move queries to SQL Server so that forms in Access use them, and the actual processing is done by SQL Server so that the front end just receives the final data? Would that reduce my overall query and processing times?

Tried migrating data from Access to SQL Server to reduce loading times and instability. Querying now takes even longer since queries are still processed in Access instead of SQL Server. Queries are too many, and complex to rewrite in SQL Server easily.

Continue reading...