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 |
:PRIV:Whs1.db | PartNum | PrmNum | RawMatNum |
JobItem.DB | JobKey | ItemNum | Thickness |
EndQuery