how about
set rs.activeconnection=nothing
conn.close
set conn=nothing

----- Original Message -----
From: "rds" <rds@a...>
To: "professional vb" <pro_vb@p...>
Sent: Tuesday, September 24, 2002 6:11 PM
Subject: [pro_vb] ADO Connection ...

> Is there a way to close the connection in a ADODB.Connection object
>
> without loosing the recordset data
>
>
>
> Cheers Kilian
>
>
>
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>
>

*********************************************************
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com