SQL 10000 record limit

  • Thread starter Thread starter asdfg
  • Start date Start date
A

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?
 
Hi,
I am running a query, not using a form.
Also, I do not have the following option...

You can also set the default behaviour in Tools, Options, Advanced, Default
Max Records.
Click to expand...
 
Back
Top