fc2a5c0d   
   From: ttoews@telusplanet.net   
      
   On Mon, 16 Apr 2012 08:10:45 -0700 (PDT), eighthman11   
    wrote:   
      
   >The problem is when doing the bulk insert I have to have the records   
   >insert in the exact same order as the source file or I can't loop   
   >through the records and update the proper "day worked".  The bulk   
   >insert; inserts the record in the exact same order as the text file   
   >about 90 percent of the time, but occasionally it just goes crazy.   
      
   Are you using an Int identity field and then subsequently sorting by   
   that column?  In Access if you have an autonumber field then the   
   records will be sorted in insert sequence if you sort by that field.   
      
   Now a problem can arise if multiple folks are doing the insert at the   
   same time.   
      
   Tony   
   --   
   Tony Toews, Microsoft Access MVP   
   Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm   
   Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/   
   For a convenient utility to keep your users FEs and other files   
     updated see http://www.autofeupdater.com/   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)