The query cannot be completed. Either the size of the query result is larger than the

[urooj sabar]

when i try to run a query having name field from 5 different tables it gives following error.
"The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result."

how can i solve it?
thank you.

[zmbd]

You select a smaller number of records to return or you increase the amount of physical memory in the PC and on the harddrive. Which one depends on which one caused the issue.

[urooj sabar]

Thank you..!! i'll go for the first one :)

[TheSmileyCoder]

You would have to track down the issue. How large is your db currently? Unless your bringing massive amounts of data together or have a 5 tables which are not linked together (which cause multiplication of returned results) I don't usually see anyone hitting the 2gb limit. Are you returning alot of fields? Desribe your query, describe the fields.

[NeoPa]

I think the first thing you do, even before posting your question, is to put together the basic relevant information to make the question a sensible one. The very least that would include is an explanation of what your query is attempting to do and the SQL you are using that causes the error. Posting a question without that information is a very strange approach.