Do you close Database and all Recordset objects this way:
rs1.Close
set rs = nothing
rs2.Close
set rs2 =nothing
'.
'.
db.Close
set db = nothing
This steps should kill your current connection and clear memory
Vlad
| CodeGuru Home | VC++ / MFC / C++ | .NET / C# | Visual Basic | VB Forums | Developer.com |
|
Results 1 to 2 of 2
Thread: Killing DAO connection..Threaded View
|
Click Here to Expand Forum to Full Width |