"Query Too Complex" makes no sense

[funderburgh]

I am getting a 3306 "Query Too Complex" message on a query in my application. This is a 10 year old distributed application in our private school. The database is on my computer and everyone, including myself accesses the data through the network. I was brought a question about a particular report that relies on this query and when I run the report on my native - "non-distributed" version of the application I get this message. If I go and run the report on any other work station (presumably the distributed version of what I am using) there is no message.


Did I make a code change that is not in the distributed version? I have restored backups from several months ago (and sooner), I get the message every time.


Could I be having a resource issue with my machine? I started with a clean boot stripped down to the basics at start up - same message.


Could it be the data? I only have one set of the data.


I am stumped. Yes, it is a complex query, but it has worked for years and is working on the distributed versions.


I am vexed and any brainstorming would be greatly appreciated.

John

 

[llkhoutx]

The message means what it says. Break the query into multiple queries. Query1 references query2, etc.

 

[funderburgh]

The point I am trying to make is that this is a working query and has not changed for perhaps a year. It is working on every workstation except mine. Of course I could put on my programming hat aand mess with the query, but the facts presented here make me suspect that there is an environment issue, something with my workstation.

 

[llkhoutx]

Windows or Access updated. The message means what it says. Again, break the query into multiple queries. There's always lots of ways to solve a particular problem.

 

[JHB]

... Of course I could put on my programming hat aand mess with the query, but the facts presented here make me suspect that there is an environment issue, something with my workstation.

When did you last run the query/report without problem, did anything change in the mean time, new computer, reinstalling Windows/MS-Access, Windows updates etc.?
If me, would take a copy of the query and reduce it, until I find the part that cause the error.

If a query is "Query Too Complex", is an error message in MS-Access and only mean it is to complex for MS-Access to handle, you can get it where only a few fields are involved, so ...