Viewing posts from: VBA

Troubleshooting Potential Errors when Using Transactions in Ms Access – Do NOT Close the Workspace!

By Darragh|Ms Access Tips, VBA|Be the first to comment!

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 [...]