SQL access 10,000 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?
 
asdfg said:
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?
Click to expand...

It's a setting in options. Not sure of the specific location.
 
There is an option tools/options, Edit/Find, but not sure that is it.

Is it always exactly 10,000? Seems too round a number not to be a setting
somewhere.
 
asdfg said:
Hi,

I can't find this option anywhere.
I am using access 2000
Click to expand...

This is a project (ADP) right, not an MDB? I have never used those, but am
fairly certain that by default there is a 10,000 row default setting that can be
changed "somewhere" in the options.
 
In ADP, the default settings of 10000 is in the Tools / Options ... /
Advanced tab / Client-server Settings pane.

OTOH, 10000 Records is a lot of Records to pull down for a proper C/S
system.
 
It is an MDB file.


Van T. Dinh said:
In ADP, the default settings of 10000 is in the Tools / Options ... /
Advanced tab / Client-server Settings pane.

OTOH, 10000 Records is a lot of Records to pull down for a proper C/S
system.
Click to expand...
 
asdfg said:
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.
Click to expand...
CREATE PROC myProc
AS
SET NOCOUNT ON
-- get all records
SET ROWCOUNT 0
-- now the SQL
SELECT * FROM myTable WHERE Condition
GO
 
Back
Top