Query corrupts itself...

  • Thread starter Thread starter centre21
  • Start date Start date
C

centre21

Perhaps someone has seen this - I have a client who uses MS Access to
keep track of vendors and booths for trade shows. What happens is that
the data in the tables is fine, but one of the queries keeps returning
the wrong results, so they have to delete and re-create the query and
then it runs just fine. It's a very simple query, just matching up
vendors with booth ID numbers and number of actual booths - nothing
real involved. And the user in question is running this on MS Access XP.
 
Post the query's SQL... that will help us see if it's related to one of the
Jet/ACCESS bugs.
 
Perhaps someone has seen this - I have a client who uses MS Access to
keep track of vendors and booths for trade shows. What happens is that
the data in the tables is fine, but one of the queries keeps returning
the wrong results, so they have to delete and re-create the query and
then it runs just fine. It's a very simple query, just matching up
vendors with booth ID numbers and number of actual booths - nothing
real involved. And the user in question is running this on MS Access XP.
Click to expand...

I've never seen this particular error. Have you used Tools... Database
Utilities... Compact and Repair to repair possible corruption in the
database? If not, try deleting the query; compact; and recreate the
query. Perhaps you could also post the SQL of the query and an example
of the "wrong" data, maybe there is something non-obvious wrong with
it.

John W. Vinson[MVP]
 
I'll check with the client to see if they've tried any of these fixes.
I'll also see if they're kosher with posting the query.
Thanks, John.
 
Be sure that Name AutoCorrect option is turned off -- it often causes weird
results that seem inexplicable.
 
Back
Top