[AccessD] DAO Recordset/Database is Open?

Happy to help Vlad. Note though that my solution only looks to see if you
(ie the cuuent instance of Access) have that recordset open. The others were
looking to see if the underlying table was open anywhere. Be sure to choose
the right one for what you're after.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: RE: [AccessD] DAO Recordset/Database is Open?
Date: 19/10/04 13:09

>
> Andy,
>
> You're a star. Thanks to Gustav and Rocky for their suggestions. For the
life of me I couldn't come up with that. I love this list!
>
> Vlad
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
> Sent: Tuesday, 19 October 2004 10:44 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] DAO Recordset/Database is Open?
>
>
> Hi Vlad
>
> How about:
>
> If rst Is Nothing Then
>
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
> --------- Original Message --------
> From: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> To: Access Group E-mail <accessd at databaseadvisors.com>
> Subject: [AccessD] DAO Recordset/Database is Open?
> Date: 19/10/04 12:26
>
> >
> > Guys,
> >
> > Does anyone know how, using DAO, to check whether a recordset is
currently
> open and also whether the database is currently open. In ADO you can use
> &quot;State&quot;, but there seems to be no equivalent in DAO...
> >
> > Any ideas?
> >
> > Vlad
> >
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> >
> >
> >
>
> ________________________________________________
> Message sent using UebiMiau 2.7.2
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2