SQL Server accepting Access queries?
Assuming your queries are against regular Access tables, you should be able to replace the Access tables with Linked Tables to your SQL Server.  The Linked SQL tables have to have the same names and structure to in order for this to work.  I don't have the 2008 version of Access so I can't give exact instructions but look in the menus for something like External Data or Link Tables, then look for ODBC and create a "Link to the data source..." and follow the instructions to setup an ODBC data source to your SQL server, you can Google how to setup an ODBC connection if you need to.

You may need to setup the ODBC connection outside of Access beforehand depending on your security settings.  Keep in mind that if your OS is 64-bit you need to use the 32-bid ODBC administrator console to setup an ODBC data source that Access can use. (Wasted a day figuring out that one.)