Retrieve a result set in Access 2000 from a Stored Procedure

[cmmrfrds]

Anybody familiar with Access 2000 using an ADO recordset and retrieving data from a stored procedure in Sql Server 2000. I can retrieve the results set from the stored procedure when I execute the stored procedure directly from the development environment in Access. I need the result set from the stored procedure to be the recordsource in a Form or Report. How do I equate the result set from the SP to the recordsource in my Access Report??

Thank you,
Jerry

 

[tlbroadbent]

One way to do it is to create an Access pass-through query which executes the SP. Use the pass-through query as the source for the report. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot