Back

VB041

Recordset or connection not closed

Visual Basic 6
Warning
VB6

A locally opened ADO/DAO recordset or connection that is never closed holds locks and pool connections until garbage collection

a locally opened ADO/DAO recordset or connection that is never closed holds locks and pool connections until garbage collection.

Why this severity

a locally opened ADO/DAO recordset or connection that is never closed holds locks and pool connections until garbage collection.


Known false positives

ownership transferred via a path the rule cannot see; Set x = rs transfers are already exempt.

Remediation example

    rs.Close

Reconnecting… Connection lost. Reload