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
*$ 4 8971
Starbuck,
I am afraid you haven't provided enough information to be of help. What
error is she getting? What statement is she running? etc.
By the way, you can search the archive of the public Microsoft
SQL-Server forums on Google (without registration). Have a look at http://groups.google.com/groups?hl=e...blic.sqlserver
Hope this helps,
Gert-Jan
Starbuck wrote: 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
*$
--
(Please reply only to the newsgroup)
The error message is "Query is too complex".
The Query that is being run combines 2 tables into
a table query. There is only one join.
The issue seems to be that this query runs on another
machine just fine... They have similar hardware,
and software, but it fails with a "Query is too complex"
error on her machine.
We dont feel that this is in fact a "complex" query.
Point is, I need this to run on her machine, but I am
unable to determine what the differences are.
Could this be a connection issue?
I'm really shooting in the dark here, so any suggestions
are greatly appreciated.
thanks again.
*$
On Thu, 05 Aug 2004 19:43:08 +0200, Gert-Jan Strik
<so***@toomuchs pamalready.nl> wrote: Starbuck,
I am afraid you haven't provided enough information to be of help. What error is she getting? What statement is she running? etc.
By the way, you can search the archive of the public Microsoft SQL-Server forums on Google (without registration). Have a look at http://groups.google.com/groups?hl=e...blic.sqlserver
Hope this helps, Gert-Jan
Starbuck wrote: 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
*$
Starbuck (St******@Bogus Domain.com) writes: The error message is "Query is too complex".
The Query that is being run combines 2 tables into a table query. There is only one join.
The issue seems to be that this query runs on another machine just fine... They have similar hardware, and software, but it fails with a "Query is too complex" error on her machine.
We dont feel that this is in fact a "complex" query.
Point is, I need this to run on her machine, but I am unable to determine what the differences are.
Could this be a connection issue?
I'm really shooting in the dark here, so any suggestions are greatly appreciated.
If you are in the dark, guess how dark we are in, who don't even know
what environment you are using, or how the query looks like.
That much I can tell, that the message "Query is too complex" does not
appear in master..sysmess ages, so it is not likely to be a message from
SQL Server. To be able to assist further we need to see the query,
we need to know what environment the user gets this error in, and we
need to know which database engine you are working with. (It should be
MS SQL Server, else you are posting to the wrong newsgroup.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Starbuck" <St******@Bogus Domain.com> wrote in message
news:sp******** *************** *********@4ax.c om... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Robin Tucker |
last post by:
Hi,
Can anyone tell me how to select the "most recent" date values from a
grouped query? Consider the following:
CREATE TABLE . ( NOT NULL , NOT
NULL , NOT NULL ) ON
This is a simplified adjacency list. What I want to do is find the highest
|
by: Brian Angliss |
last post by:
I'm relatively new to scripting in JavaScript, so I'm not too
surprised I'm having difficulty scripting up an animation effect for
my personal site.
What I'm trying to do is the following: When I go onMouseOver on a
button in a nav bar, I want that button to switch to a different image
while at the same time another blank image changes as an animation to
an associated image. When I go onMouseOut, the bar image reverts back
to the...
|
by: Ellen Manning |
last post by:
Using A2K. In my table I have the field "Grant" which can have a
value or be null. I have a query that counts the number of records
and has a Where clause on the Grant field. The query won't work when
Grant is null. What's the proper syntax for getting it to work when
Grant is null?
Here's my Where criteria:
!!
|
by: Susie Swint |
last post by:
I have the following IIf statement which worked in Access 95 but will
not work in Access 2002. The error message I get is that the expression
is typed incorrectly, or is too complex to be evaluated. Can you tell
me what is wrong with the statement?
Audits: IIf(. Is Not Null,.,IIf(. Is Not Null,.,IIf. Is Not Null,.,IIf(. Is Not Null,.,0))))
Thanks!
|
by: Matt |
last post by:
Hi all, Thank you for taking the time.
I have a database with 45 tables on it. 44 tables are linked to a main
table through a one to one relationship.
My question is, is there no way i can have a query that will pull a
single field from all the tables. In other words i should have 44
fields. when i try to do that same, i get an error message saying
"Query is too complex"
| |
by: Mike Bridge |
last post by:
I am using MS Access 2003, and I typed in a query in SQL view which was working fine. Now when I open it, it gives me
the error "Join expression not supported". Apparently, Access "fixed" it for me.
Unfortunately, I can't correct it because when I click "OK", the window disappears. I don't see any way to open the
query directly in SQL view, and both the Design and Data views exit as soon as I close the error dialog.
Is there any way...
|
by: Russ |
last post by:
I tried the following:
>>> x = complex(4)
>>> y = x
>>> y *= 2
>>> print x, y
(4+0j) (8+0j)
But when I tried the same thing with my own class in place of
"complex" above, I found that both x and y were doubled. I'd like to
|
by: wayniac |
last post by:
I am having a problem when I try and remove several fields from the lookup. I have many fields, and the error I am getting is "Expression is too complex", is there anyway of going around this or turning an option off so I may proceed further. From what I have researched, this error is because I have too many fields be filtered in the onload property of the form.
Thank you
|
by: cori25 |
last post by:
Paycode': IIf(="01","Meeting",IIf(="02","Training",IIf(="04","Special Project",IIf(="05","QC",IIf(="06","MDU",IIf(="07","UG",IIf(="08","2nd Man",IIf(="09","Sr Tech Other",IIf(="10-1","Loan Out to Nassau",IIf(="10-2","Loan Out to Suffolk",IIf(="10-3","Loan Out to CTHV",IIf(="10-4","Loan Out to Bronx",IIf(="10-5","Loan Out to Brooklyn",IIf(="10-6","Loan Out to NJ North",IIf(="10-7","Loan Out to NJ...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |