This could be due to not properly closing recordset and connection objects and setting their references to nothing. Make sure this is done every time you use these objects:
myRecordset.close
myConnection.close
set myRecordset = nothing
set myConnection = nothing