closing recordsets...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

In any function where I am using a recordset, I always set the recordset =
nothing when I am finshed. SHould I also be issuing a .close?? or does the
setting to nothing essentially do the same thing?

Thanks,

Brad
 
Brad said:
In any function where I am using a recordset, I always set the recordset =
nothing when I am finshed. SHould I also be issuing a .close?? or does the
setting to nothing essentially do the same thing?
Click to expand...


A good coding rule is: If you open it, then you should
close it. The opposite is also true: If you did not open
it then do not close it.

For safety's sake: If you Set a variable, then set it to
Nothing.
 
Back
Top