By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Display Multiple Recordsets from a Stored Procedure

P: 2
I'm running a pass-through query in Access that executes a stored procedure. However the Stored procedure has multiple record sets(5). When the query is ran it only displays the first Record set, how do I display all of them?

Here is the exec stored procedure code for the pass-through query. The stored procedure also has a View parameter in the ' '

exec [STORED PROCEDURE NAME] 'view2011humors'

Is the only way to go about this using VBA? I feel like you should just be able to display it all.
Jun 1 '12 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,366
You can't. Union the results if they have the same fields. Otherwise, put each one in a different stored procedures and create different pass through queries.
Jun 1 '12 #2

P: 2
I have to be able to just use this stored procedure so I guess my only option is to use VBA to read through the different recordsets. Does anybody have code for doing this in an Access Report?

Thanks for the quick response Rabbit
Jun 1 '12 #3

Rabbit
Expert Mod 10K+
P: 12,366
You can use the .NextRecordset method to move to the subsequent recordset.
Jun 1 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.