How can I determine if a database or recordset is open or has been closed?
Such test as If IsNull(Mydb), If Mydb.Name>"" or any attempt to read a property of the database or recordet once it has been closed, produces an error. Closing seems to destroy it.
IsEmpty gives the same result whether open or closed.
I resorted to having another flag variable that I make true if it is open but it would be neater if there was direct way.
Such test as If IsNull(Mydb), If Mydb.Name>"" or any attempt to read a property of the database or recordet once it has been closed, produces an error. Closing seems to destroy it.
IsEmpty gives the same result whether open or closed.
I resorted to having another flag variable that I make true if it is open but it would be neater if there was direct way.