470,831 Members | 1,342 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,831 developers. It's quick & easy.

Access 2000 union query fails silently or with "data type mismatch in criteria expression"

The mdb is considerable size 70 +- mb. A complex union query was
working well, but when an additional union select... was added into
the query, selecting identical fields from a different source, it
began to have problems.

Failure was observed only in a few PC's at first. For example, in an
NT 4.0 SP6 PC, it continued to work OK. But in my Win 2k laptop, it
failed. As the union query was gradually simiplified in testing, the
failure mode first changed from "data type mismatch in criteria
expression" to a quiet failure with no output data, then to correct
function. Importing all objects into a new clean container did not
help. The workaround was to use a series of append queries into a
temporary table in lieu of union queries.

I found a couple of useful references in my search of NG's when
diagnosing the problem, and wish to thank members of this group for
many helpful postings. In this case, maybe I can benefit other
programmers by pointing a finger at an untrapped error due to resource
problems with large queries (perhaps just union queries) in Access

Please do not ask me to quantify "large." Embarrassingly large. But,
it may, in fact, be slightly PC or OS dependent.

I am not a db expert, but have several years experience programming
Nov 12 '05 #1
0 3745

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by TheCoder | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.