From: greens@diamondsg.com   
      
   > the default block size of the BDE is 4096.   
      
   > JobItem.DB has 1050412 records.   
      
   > I do not believe table size is an issue   
      
   you're kidding, right?   
      
   how big is that million-record table?.. why do you still have that tiny   
   block size?.. and most important, do you realize what happens to the size of   
   an answer table with an outer-join, or something like "not" in the   
   parameters?   
      
   so, do two things.. do the repair to rule out corruption, and make a bigger   
   table to rule out size.. then get back to us..   
      
   --   
   Steven Green - Myrtle Beach, South Carolina USA   
      
   http://www.OasisTradingPost.com   
      
   Oasis Trading Post   
   - Collectibles and Memorabilia   
   - Vintage and Custom Lego Creations   
      
   Diamond Software Group   
   - Paradox Support & Sales   
      
   Diamond Sports Gems   
   - Sports Memorabilia and Trading Cards   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)