Access and SQL Server Queries

  • Thread starter Thread starter paul reed
  • Start date Start date
P

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
 
paul reed said:
Hello,

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

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?
Click to expand...

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.
 
Back
Top