Re: Runtime error 3707

From: mona (mona_at_discussions.microsoft.com)
Date: 03/22/05 

Date: Tue, 22 Mar 2005 17:08:33 +0530

Hi SBC,

For open Recordset objects or for Recordset objects whose Source property
is set to a valid Command object, the ActiveConnection property is read-only.
Otherwise, it is read/write.

So, you need to close your Command object before you close your active connection.

HTH

Mona

"SBC" <SBC@discussions.microsoft.com> wrote in message news:95C72302-15B4-4ABE-B310-D17C8844831F@microsoft.com...
> Hello,
>
> After setting the object below to Nothing, I receive the following runtime
> error...
>
> "The application cannot change the ActiveConnection property of a Recordset
> object that has a Command object as its source."
>
> oRS.ActiveConnection = Nothing
>
> The ActiveConnection object is being set to Nothing after executing a stored
> proc. Would someone be able to give me an idea of why setting the
> ActiveConnection to Nothing?
>
> Thank you very much for you help
>
>