Accessing Stored Procedures

  • Thread starter Thread starter Paul Reed
  • Start date Start date
P

Paul Reed

Hello,

How can one use Access to build reports but pass parms
into an MSSQL Server Stored Procedure to actually get the
result set for the Report?

Regards,

Paul
 
If using an .mdb, use passthrough queries.

Before opening the report (or during the Load event of the
report itself), you would modify the .SQL property of the
passthrough query's querydef object.

And ooh does this rock. Just lookup passthrough queries
to figure out how to set the connection and stuff.

David Atkins, MCP
 
Back
Top