Yes...there is no need to keep a connection open when it's not being used.

You can add a parameter to that sub to say which DB you want to connect to...my app hits 2 DB's, so I pass in the DB name I want to access.
Also you can have a parameter to say whther the recordset is read-only or not...
You could also add functionality to deal with multiple updates using transactions on the ado connection object.

Woka