Found the problem...My procedure that fires the stored procedure to create the recordset had a close databases all in it.....Thanks for your help