Query Too Complex - works on one machine, but not mine

[dktenor]

I have received a file from another department - when I try running a query I get the message "Query Too Complex".

1) This query runs fine on the machine of the person who created it
2) I am on the same version of ACCESS as the person who created it.
3) one of my colleagues in my department can read it and run it properly.

I'm thinking that perhaps there is some sort of setting that is necessary on my machine. Thoughts? Ideas?

Thanks,
Doug

 

[richary]

You don't state the database/version number, but I'm assuming its Access.

The following may help you, even if you are running a later version of Access than those stated in this KB article.

http://support.microsoft.com/?kbid=103429

 

[dktenor]

I am running ACCESS 2002, SP-2. Is this what you are asking?

My biggest confusion is why do two computers - each running ACCESS 2002, SP-2 - one computer runs the query fine, the other doesn't?

I'll go study the Microsoft knowledge base article if there is a clue there.