From: computer_hero@coldmail.com   
      
   It's all in the Help!   
   Optional. Discontinues association of objectvar with any specific object.   
   Assigning Nothing to objectvar releases all the system and memory resources   
   associated with the previously referenced object when no other variable   
   refers to it.   
   /Henning   
      
   "David C. Barber"  skrev i meddelandet   
   news:oJ6dnVs7wfYkAjPcRVn-gg@comcast.com...   
   > Why is it that after I close an ADO recordset defined locally   
   >   
   >     Dim adoRS as New ADODC.Recordset   
   >   
   > that so many examples insist that I should set it to nothing as well?   
   >   
   >     adoRS.Close   
   >     Set adoRS = Nothing   
   >     Exit Sub   
   >   
   > Isn't it sufficient to have it go out of scope when I exit the subroutine?   
   >   
   > Thanks!   
   >   
   >     *David*   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)