[AccessD] Another corrupted ACC97 database query.

Hi everyone,

We have a BE/FE system that I just released an update for.  There is not any
apparent corruption in the FE or BE.

But...
One of the things done in this release is to append all of the data from one
table to another one (both already existing).  Using this one BE, an error
message is raised.  Something to the effect of "Error in criteria."  Thing
is, there is no criteria on this query.

So...
I rerun the conversion code again and stop the code before the query runs.
I past the SQL code into the designer and run it in non-update (select mode
also) mode.  The query only returns about 400 records when there are over
1320 records in the source table.  Now, if I take that same query and run it
in the BE db directly, it pulls all of the records correctly.

I have decompiled, compacted, repaired, and imported the FE into a new db.
All of that appears to be fine.  But when I try to use JetComp, I get a
message box that says "Error compacting database."  I have tried to JetComp
it after doing the above in several different scenarios. I also tried just
importing the tables (from the FE) into a new db.  Jetcomp gives the same
error.  I get the same also with just importing the queries and forms.  I
quit there.

Anyone have any ideas?

Thanks,
Bobby