Access and SQL Server Queries

[paul reed]

Hello,

Is there a way to execute stored procedures on SQL Server and make them the
source of a report?

How can someone basically use Access as the reporting product but have the
queries executed physically on the SQL Server box?

Regards,

Paul

 

[Rick Brandt]

Hello,

Is there a way to execute stored procedures on SQL Server and make them the
source of a report?

Yep. If the SP need sto have variable parameters fed to it then it is a bit
more complicated though. To do this with ODBC I usually modify the SQL of the
query containing the SP call and then run it.

How can someone basically use Access as the reporting product but have the
queries executed physically on the SQL Server box?

To *guarantee* that the query is processed 100% on the server you need to use an
SP or a Pass-Through query. Most standard queries against SQL Server linked
tables will still be processed on the server to varying degrees depending on the
structure of the query.