Object closed error!

I just figured out (again!) why I get this error while trying open/use
an ADO recordset from a stored procedure (acCmdStoredProc), while using
commandText worked just fine.

"SET NOCOUNT ON"

Apparently the "(xxxx row(s) affected)" msg output by SQL Server jacks
up the recordset object.

adding "SET NOCOUNT ON" at the top of your stored procedure will fix
this issue.