Memory involved with opening recordsets

  • Thread starter Thread starter Andy Levy
  • Start date Start date
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 ?
 
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
 
Back
Top