How to check if a recordset is opened ?

[icongroup2003]

Ok problem solved.


Apparaently, there is a property .state which allow me to check if it is opened or not.

if rs.state = adStateOpen then rs.close

That solved my problem.

Cheers !!!