SQL 10000 record limit

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?
 
A

asdfg

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL/access 10000 record limit 1
SQL access 10,000 record limit 8
Queries missing in ADP and SQL after upsizing 4
Access FE, SQL BE, Some tables, won't let me edit (or delete) my records! 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Upsizing to SQL Server 6
Access 2003 max rows 14
10000 row limit 3

Top