Accessing Stored Procedures

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
 
G

GreySky

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Insert Index into a Table 1
Access 2002 change report header text 0
SQL Stored Procedure 1
Access pass-through query to Oracle 10g stored procedure - results 1
MS Access 2010 Training database 0
Access ADP Form and Stored Procedure as RecordSource 0
open SQL store procedure from adp 0

Top