I was doing some recordset juggling in vba and out of habit I usually close every object I open up explicit using the .close method on that object.
For example if I open up a database using something like this
Dim db as dao.database
Set db = currentDb
I will close it at the end of the function or procedure
Db.close
Set db = nothing
When using transactions, you make use of the workspace collection and you open it along the lines of
Dim myWrk as dao.workspace
Set myWrk = DBEngine.Workspaces(0)
As usual, I want to close this at the … Read the rest