I posted this in the MS Access group, but no luck.
------------------------------------------
I've got another stored procedure in the same app that returns multiple
recordsets and the code works.
But now I've written another SP and the code traps out with the 3251 message.
The SP is writing two recordsets.
When I run the SP in Query Analyzer, both recordsets appear.
But when I step through the code, when the first RS should be there, it's
"Closed" and nothing I've tried will make it open.
Provider=SQLOLEDB.1 (which works on the other screen...)
Seems like I've been here before, but I can't remember what the problem was.
--
PeteCresswell