[AccessD] Another corrupted ACC97 database query.

Bobby Heid bheid at appdevgrp.com
Wed Apr 23 10:23:35 CDT 2003


The exact error message when running the query in code is "3464: Data type
mismatch in criteria expression."  And like I said earlier, there is no
criteria in the query.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bobby Heid
Sent: Wednesday, April 23, 2003 11:11 AM
To: 'accessd at databaseadvisors.com'
Subject: [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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list