Bobby Heid
bheid at appdevgrp.com
Wed Apr 23 12:20:37 CDT 2003
Hey again, I have discovered the problem (at least with the query bombing). The table being appended to had a numeric field for a particular field, while the source table had that field as text. And of course, there was text in a few of the fields. I can move on now! :) 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:24 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Another corrupted ACC97 database query. 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com