[AccessD] Setting objects to Nothing

  Always.  Also do this:


  On Error resume next

  If not rstMyRecordSet is nothing then
    rstMyRecordSet.Close
    Set rstMyRecordSet = Nothing
  End If

  Always a good idea to clean up after yourself.  At least in the case of
Access, you can't always count on it to do the job for you.  

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, February 16, 2010 10:00 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Setting objects to Nothing

When referencing a Reference object, do any of you bother with 

Set ref = Nothing

????

Susan H. 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com