VB6 and ADO data access

N

Newbie2005

I'm trying to migrate VB6 code that uses DAO to use ADO instead. My
question is regarding best practice with ADO.

Say when I open a DB connection, should I keep the connection open
until I'm finished with the application or do I close it everytime I
open it. Also, is there a good ADO data access tutorial that you can
point me to?

Thanks
 
Top