SQL Query data set size

Hi Experts,

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

http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_28342884.html

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?
DColinAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
the recordsize limit return by a query is 1 gb

see this link

http://office.microsoft.com/en-us/access-help/access-specifications-HP005186808.aspx
0
 
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.
0
 
DColinAuthor Commented:
capricorn1

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?
0
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.

All Courses

From novice to tech pro — start learning today.