Is connection closure implicit?

X

XP

Using Office 2003 and Windows XP;

Just a reality check here;

1) When using: CurrentProject.Connection.Execute sSQL
The connection is implicitly closed after execution is complete, right?

2) When using a structure like:

Dim rsADO as ADODB.Recordset
Dim sSQL as String

sSQL = "SELECT * FROM MyTable;"
Set rsADO = CurrentProject.Connection.Execute(sSQL)

Technically, the recordset should be closed as in:

rsADO.Close: Set rsADO = Nothing

Right? But, is the connection implicitly closed here as well?

Thanks for the help.
 
Top