closing a recordset

robrodp
robrodp used Ask the Experts™
on
Once a recorset is closed is it necesary to set it to nothing?

If so what is the statement?

Rs=nothing
Set Rs=nothing?

What happens if this is not done?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2007

Commented:
Yes, it frees up the resources used to intitalize it, and disconnects from the source.
Top Expert 2007
Commented:
Set Rs=nothing is correct.

If not done, problem depends on how much traffic you have.  The more traffic, the more resources allocated for each recordset, the poorer the server runs.

Always set to nothing.
robrodpProgrammer

Author

Commented:
So te correct sytax is:

Set rs=nothing
Top Expert 2007

Commented:
correct.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial