The Question and Answer Board

[Dimension]

Bob: not sure if anyone responded to any of these thoughts of yours already...just getting home.

regarding the global.asa. that in essense is a wrapper to the database access code as you probably surmise by now. it is usually not something you want to touch or modify. if you need to do anything, it is best to do it in your custom code and not play with that...

your are correct, there is no Recordset.closeAll, and unlike the old DAO, recordset and connections are totally separate.
I think the best thing is to close recordset immediately after using them. you could consider disconnected recordsets if you need to still maintain a reference to the data.
Also, i do NOT believe closing the connection will close all recordset and will likely lead to memory leaks. This is especially true if you are using connection pooling.

you mentioned several times that recordsets were being closed "AFTER" the cleanup routine. is it possible they are being executed/opened Asynchronously? if so, it is likely that you may not be able to close until they have finishing processing/fetching.

i'm leading to think the issue may be what you mentioned yesterday with session variables. has clearing that out helped any?