From: jim.giner@suny.edu   
      
   first off - there is no answer table mentioned.  Did you 'type' this up   
   manually?   
   "Joseph Misko"  wrote in message   
   news:492d8a54$1@pnews.thedbcommunity.com...   
   >I have a QBE file that will run fine under many circumstances, but when   
   >there is more data in the first table (the second table is not changing   
   >right now), then the query errors. The actual query is pasted below from   
   >the QBE file.   
   >   
   > 1. In code, the return value is false with no additional information on   
   > the stack.   
   > 2. When run directly from ProView, it gives error "Expecting a column   
   > separator in table header" (immediately, the query does not even begin to   
   > run).   
   > 3. When opened in design view and run, the query begins to execute and the   
   > progress bar displays for about 10 full seconds and then it gives error   
   > "Corrupt file - other than header."   
   >   
   > I am not able to make sense of this situation, but if anyone else has   
   > experienced something similar to this and has a suggestion, I would   
   > appreciate it. Neither of these files are corrupt.   
   >   
   > Many thanks,   
   > Joe   
   >   
   > Query   
   >   
   > :PRIV:Whs1.db | JobNum | JobKey                              | JobFgKey |   
   >              | Check  | Check _partjk!, _prmjk!, _rawmatjk! | Check    |   
   >   
   > :PRIV:Whs1.db | PartNum         | PrmNum         | RawMatNum         |   
   >              | Check _partdim! | Check _prmdim! | Check _rawmatdim! |   
   >   
   > JobItem.DB | JobKey    | ItemNum    | Thickness                |   
   >           | _partjk   | _partdim   | Check as PartThickness   |   
   >           | _prmjk    | _prmdim    | Check as PrmThickness    |   
   >           | _rawmatjk | _rawmatdim | Check as RawMatThickness |   
   >   
   > EndQuery   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)