SQL access 10,000 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?

 

[Rick Brandt]

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?

It's a setting in options. Not sure of the specific location.

 

[asdfg]

Hi,

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

 

[JohnFol]

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.

 

[Rick Brandt]

Hi,

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

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.

 

[Van T. Dinh]

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.

 

[asdfg]

It is an MDB file.

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.

 

[Van T. Dinh]

Have you checked the MaxRecords Property of your Queries?

 

[Gary Walter]

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.

CREATE PROC myProc
AS
SET NOCOUNT ON
-- get all records
SET ROWCOUNT 0
-- now the SQL
SELECT * FROM myTable WHERE Condition
GO