Niall,

I am pretty sure you cannot have the ADO equivalent of
the code in the link you pointed out. This is because
with DAO all recordsets are opened in the context of a
database hence you can actually cycle through the
recordset collection in the database object and do
what you would want with the individual recordsets.
But with ADO there is no "Recordset Collection" 

HTH
Francis.

 --- "Niall Hannon (ext. 772)"
<Niall.Hannon@f...> wrote: > Hi,
> 
> Is there an ADO equivalent to the source code in the
> following link. The
> link shows some code to close all open recordsets in
> VB when exiting the
> application. However, it is written in DAO - any
> equivalent for ADO?
> 
> http://www.vbsquare.com/databases/tip382.html
> 
> Thanks
> Niall
> 
> 
>
**************************************************************************
> The information contained in this e-mail is
> confidential,
> may be privileged and is intended only for the use
> of the
> recipient named above. If you are not the intended
> recipient or a representative of the intended
> recipient,
> you have received this e-mail in error and must not
> copy,
> use or disclose the contents of this email to
> anybody
> else. If you have received this e-mail in error,
> please
> notify the sender immediately by return e-mail and
> permanently delete the copy you received. This email
> has
> been swept for computer viruses. However, you should
> carry out your own virus checks.
> 
> 
> Registered in Ireland, No. 205721.
> http://www.FINEOS.com
>
**************************************************************************
> 
> 
> 
> ---
> 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
> 

=====


__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com