SQL stored procedure with multiple data sets
Hi guys, 1st post here...
We are using SQL2008/64 (YAY!) and Access 2003 (BOO!)
I have an established SP that generates multiple data sets. I can get at the first dataset using either a pass through query or an ADODB connection in VBA, but I cant find anything on the net about how you would navigate multiple results sets in Access (I know it can be done in .NET)
Is this possible and if so, how do I configure the access objects to handle it (I guess I need an array of Recordsets??)
Thanks in Advance