If your "reuse" means use the same connection object serval times in one
project, of course you can.
I usually use the connection object and recordset object like this sample:
Dim cn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cn.Open ConnectionString
' if you want update the recordset and database, you should give a lock
rst.Open "select id,name from person where id=1", cn, adOpenDynamic,
adLockOptimistic, adCmdText
rst!Name = "John"
rst.Update
rst.Close
Quote:
> Can i reuse the ado connection object after a select has returned a RS
> via the connection. If so can i perform and update on the same records
> as returned in the recordset. What implications will this have for
> record locking.
> Sent via Deja.com
> http://www.deja.com/
ADO Connection Reuse