Memory involved with opening recordsets

A

Andy Levy

Im not sure how memory gets allocated and deallocated when I open ADO
recordsets.

If i want to write a good program, should i always insure that recordsets
are closed after using them in a procedure or function ? e.g. rst.close

Once the procedure or Function has completed are all recordsets that it
opens automatically closed ?
 
G

Gary Miller

Andy,

No, they do not automatically release all of their memory
allocations. It is best practice to Close and then set to
Nothing..

rst.Close
Set rst = Nothing

Gary Miller
Sisters, OR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When do I open my Recordsets? 14
When is recordset updated? 3
A theoretical question: how best to manage perpetual recordset needs? 25
Global Recordset which is always open 4
Use of recordset in a form 1
Cannot update a disconnected (and then re-connected) ADO recordset bound to Access 2003 form 6
Open Recordset 2
CopyFromRecordset with Filtered ADO recordset 2

Top