Scope of public proc recordset in VBA? 2

[steve728]

When closing a public procedure that has its own dimmed rs and rs.open recordset, is there an absolute need to rs.close it? I know it's just a good idea for a cleanup process at the end of the procedure but, doesn't it automatically get closed anyway? I will continue to use the .close. I've come across a lot of someone elses code that does not do it. We're talking MS Access 2000 here.

Thks in advance.

Steve728

 

[PHV]

doesn't it automatically get closed anyway
It should, but access is known to sometimes forget the cleanup stuff ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

Closing & setting = Nothing guarantees that there are no interface pointers left hanging.

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[Crowley16]

personally I usually never close the rs unless I'm going to be using it later on in the same sub, and I've not encountered any problems...

but I only do that cos I'm lazy...

--------------------
Procrastinate Now!