• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 477
  • Last Modified:

SQL Query data set size

Hi Experts,

This question relates to an SQL query I am using from this question.


The query works fine until the rows in the database table get into the tens of thousands then it starts to return fewer and fewer valid rows as I add more rows. Are there limits to the amount of data various parts of an MS Access SQL query can handle?
  • 2
1 Solution
Rey Obrero (Capricorn1)Commented:
rows return by the query are based on the criteria of the query.
it doesn't matter if you added thousands of rows to the table, they will not be shown unless the records satisfy the criteria of the query.
DColinAuthor Commented:

But the query itself is having to manipulate and sort many thousands of rows even if the final result is a single row. Are there limits to the amount of rows an MS query can handle?
Rey Obrero (Capricorn1)Commented:
the recordsize limit return by a query is 1 gb

see this link

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now