10,000 Record Limit?

[Bugga Bugga 77]

I have a database consisting of 31,000 records. I figured out how to
generate an html form from the database. The problem is that it will
only generate 10,000 of the 31,000 records. There must be something
in Access that limits output to 10,000 records. Is there away around
it? I tried to figure out how to break the records down into smaller
sets, but haven't been able to do that either.

Anyone have any ideas?

Thanks.

BB

[Pieter Linden]

Bugga Bugga 77 <bu**********@yahoo.net> wrote in message news:<oa********************************@4ax.com>. ..

I have a database consisting of 31,000 records. I figured out how to
generate an html form from the database. The problem is that it will
only generate 10,000 of the 31,000 records. There must be something
in Access that limits output to 10,000 records. Is there away around
it? I tried to figure out how to break the records down into smaller
sets, but haven't been able to do that either.

Anyone have any ideas?

Thanks.

BB

I assume you did this already: ?
In an ADP, there's a property "Max Records" - default is 10,000 - set
it to
0 for unlimited.

If you had to break the data into chunks you could use the TOP
predicate... and maybe an outer join...

[Bugga Bugga 77]

On 6 Nov 2003 13:26:13 -0800, pi********@hotmail.com (Pieter Linden)
wrote:

Bugga Bugga 77 <bu**********@yahoo.net> wrote in message news:<oa********************************@4ax.com>. ..

I have a database consisting of 31,000 records. I figured out how to
generate an html form from the database. The problem is that it will
only generate 10,000 of the 31,000 records. There must be something
in Access that limits output to 10,000 records. Is there away around
it? I tried to figure out how to break the records down into smaller
sets, but haven't been able to do that either.

Anyone have any ideas?

Thanks.

BB

I assume you did this already: ?
In an ADP, there's a property "Max Records" - default is 10,000 - set
it to
0 for unlimited.

If you had to break the data into chunks you could use the TOP
predicate... and maybe an outer join...

Dear Pieter:

The only place I could find a max records was in a query. It was
blank and would not accept a 0. It goes blank when I m,ove to another
space.
BB