Monthly Archives: October 2008

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

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 [...]
Posted in Ms Access Tips, VBA | Leave a comment