variable clean-up after module runs????

  • Thread starter Thread starter Weeble
  • Start date Start date
W

Weeble

I am new to Access and I am unsure how to clean-up my variables after I am
done with them.

Other programs I have written script for always had a way. I can find
nothing for Access.

Is this needed or am I looking for something that doesn't exist?
 
VB and VBA usually clean up after themselves. Do not count on object
variables doing that. I usually close Recordsets and set them and other
objects to "Nothing":

Exit_Here:
rst.Close
Set rst = Nothing
Set db = Nothing
Set objExcel = Nothing

as an example.
 
Back
Top