*RESOLVED* Checking the state of a ado connection

[mdsoren]

I am getting an error when I try to set the active connection property of a command to an existing connection, err msg is "object already in collection". But if I pause the code before the line executes and chk the connection property it appears to be "= Nothing".

Am I missing something? When I am done with a recordset, I set the command's (which create's the rec set) activeconnection property = Nothing. I thot this released the connection, which would then require it to be reset the next time the rec set is updated.

The connection to the Access dbase is opened when the app starts and remains open until the app shuts down, I just set the active connection property of all my commands to "Nothing" when the recordsets are not actively in use.

What am I doing wrong? I ain't no database/VB expert by any means (< stating the obvious!)