[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
"State", 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