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 [...]
Troubleshooting Potential Errors when Using Transactions in Ms Access – Do NOT Close the Workspace!