SQL/access 10000 record limit

[asdfg]

I am using an access front end and sql backend, but my queries stop at
10,000 records although I know for a fact that there are more.
Query analyser brings out the exact amount therefore i know that it is an
access problem.

Any ideas?

 

[SA]

Yes, Access naturally limits data returned from views to 10,000 records by
default. If you open the view in display mode and click the last button on
the navigation buttons displayed you will see the limit settings for the
particular view, which you can increase to no limit. If you want to change
this for all views and SPs then go to the Tools -> Options -> Advanced tab
and set the limit there, with 0 = no limit.

If you are bringing that much data back over the network, you're probably
not optimizing your select criteria for efficiency.....