Problems with queries with 1 to many joins?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Running Access 2000 SP3. When I run an "unmatched" query - on a list of
items against an item master table my result is picking up a LARGE number of
items that are actually in the item master table. Running same query on
another machine with Access 2002 I do not have this problem. Is there a fix
for the problem I'm having on the machine running 2000?
 
Post the SQL from both machines and we can see if there are any differences.

Also it's entirely possible to run the same exact query on two different
sets of tables and get different results. A query is a question. The answer
can change based on the information provided. If you are linking to a table,
make really sure that you linking to the same exact table. I've seen both
'different' results and 'missing' records due to being linked to the wrong
database.
 
All queries are absolutely identical. Original data is an extracted .txt
file sitting on a terminal server file that I'm matching to is a db2 table in
our warehouse. Trouble shooting, I've copied same extract file to multiple
locations - individual pcs and different servers. Each time I run the query
out of Access 2000 I get the problem, 2002 I don't. This morning I even
tried running the original problem query - which is in a database sitting on
our terminal server, from my computer (Access 2002). Query ran fine. When I
physically log on the server itself and run the exact same query - using
Access 2000 I get the problem. Any other suggestions ???
 
Back
Top