3398b145   
   From: tom7744.no.spam@cox.net   
      
   On Tue, 29 Sep 2009 16:03:16 -0700 (PDT),   
   "imani_technology_spam@yahoo.com"    
   wrote:   
      
   You already got some good suggestions, but to answer your direct   
   question: no, transaction logging cannot be turned off as far as I   
   know. As I understand it, it's such a fundamental part of database I/O   
   that even a switch to turn it off (e.g. when in development mode) was   
   not possible.   
      
   -Tom.   
   Microsoft Access MVP   
      
      
   >We have a table that contains billions of rows.  When we try to UPDATE   
   >that table, we overload the transaction log.  What are some ways to   
   >avoid this?  Is there a way to "turn off" the transaction log   
   >temporarily?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)