SQL access 10,000 record limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

asdfg - 26 May 2005 11:36 GMT

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?

Reply to this Message

Rick Brandt - 26 May 2005 12:40 GMT

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

asdfg - 26 May 2005 12:42 GMT

Hi,

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

>> 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.
[quoted text clipped - 4 lines]
>
> It's a setting in options. Not sure of the specific location.

Reply to this Message

JohnFol - 26 May 2005 13:05 GMT

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.

> Hi,
>
[quoted text clipped - 9 lines]
>>
>> It's a setting in options. Not sure of the specific location.

Reply to this Message

Rick Brandt - 26 May 2005 13:13 GMT

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Van T. Dinh - 26 May 2005 13:32 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> > Hi,
> >
[quoted text clipped - 4 lines]
> fairly certain that by default there is a 10,000 row default setting that can be
> changed "somewhere" in the options.

Reply to this Message

asdfg - 26 May 2005 15:49 GMT

It is an MDB file.

> In ADP, the default settings of 10000 is in the Tools / Options ... /
> Advanced tab / Client-server Settings pane.
[quoted text clipped - 12 lines]
> can be
>> changed "somewhere" in the options.

Reply to this Message

Van T. Dinh - 26 May 2005 23:38 GMT

Have you checked the MaxRecords Property of your Queries?

Signature

HTH
Van T. Dinh
MVP (Access)

> It is an MDB file.

Reply to this Message

Gary Walter - 27 May 2005 22:22 GMT

>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

Reply to this Message