System resource exceeded

[bengsan via AccessMonster.com]

Hello All
I have 2 querys and when I combine, error display "System resource exceeded"
any suggest ?

I would like to thank all of you in advance for your help.
thank you all

 

[golfinray]

You can only have 255 columns in a query. You are not exceeding that limit
are you?

 

[Michel Walsh]

You probably produce a monstrous join which would require more than 2Gig of
memory to keep intermediate result:

SELECT *
FROM query1, query2



You should add a condition between the two queries (inner or outer JOIN), or
further reduce the number of records returned by query1 or by query2.




Vanderghast, Access MVP

 

[John W. Vinson]

Hello All
I have 2 querys and when I combine, error display "System resource exceeded"
any suggest ?

Please post some more information. There is obviously something wrong with the
query you're building... but we cannot see it to tell you what.

Please post the SQL view of the two queries and describe how you are
"combining" them.