"Starbuck" <St******@BogusDomain.com> wrote in message
news:sp********************************@4ax.com...
OK, first let me say that I am no DB person.
But I have a user here who keeps getting this error
whenever she does, whatever it is she does, with
databases...
A google search takes me to various forums where
I am forced to sign up before I can read any answers.
Interesting note here is that the guy in the office next
to her can run this same query without any problems.
So, can this be a hardware issue?
If I threw more RAM at this problem would that do?
Or is this strickly a coding issue?
Why would one machine run this query ok, yet another
machine generates this error?
Any pointers that you guys could throw my way would
be greatly appreciated.
Thanks
*$
I've never heard of this error before - as Erland pointed out, this is not a
native MSSQL error - however some Googling suggests that it is likely to be
either an MS Access issue, or something related to some very old data access
components (the most recent exact hit for this error in Google newsgroups is
in the year 2000). For example:
http://support.microsoft.com/default...NoWebContent=1 http://support.microsoft.com/default...NoWebContent=1 http://www.dotnet247.com/247referenc...43/216266.aspx http://www.google.com/search?sourcei...ry+too+complex
Without more information, however, it's very difficult for anyone to give
any good advice. What is the database (Access, MSSQL), what is the client
(Access, in-house app, third-party app), what are the operating systems, the
servicepacks, how is the query submitted, what is the definition of the
query and tables, what difference is there between the workstations where
the query works and does not (OS, hardware) etc.
My best guess is that you are querying an MS Access database, and the "guy
in the next office" has a more recent Windows version than the user with the
error (and therefore more recent data access components), but that's purely
speculation and very likely to be wrong. If you're not using MSSQL, then as
Erland said, you will get a better response in a forum dedicated to your
database platform.
Simon