Will a data access page only display 10,000 records? I have a database with
a table with around 40,000 records but when I go to view the DAP it only
displays 10,000. Is this the max or is there a setting to change this. I
created the DAP with the built in wizard. Can someone please help?

Check the MaxRecords property of the page.

--

Ken Snell
<MS ACCESS MVP>

"AceWill" <(E-Mail Removed)> wrote in message
news:F9C8B8E1-03AE-40DB-A030-(E-Mail Removed)...
> Will a data access page only display 10,000 records? I have a database
> with
> a table with around 40,000 records but when I go to view the DAP it only
> displays 10,000. Is this the max or is there a setting to change this. I
> created the DAP with the built in wizard. Can someone please help?

Duh! Thank you so much!

"Ken Snell (MVP)" wrote:

> Check the MaxRecords property of the page.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "AceWill" <(E-Mail Removed)> wrote in message
> news:F9C8B8E1-03AE-40DB-A030-(E-Mail Removed)...
> > Will a data access page only display 10,000 records? I have a database
> > with
> > a table with around 40,000 records but when I go to view the DAP it only
> > displays 10,000. Is this the max or is there a setting to change this. I
> > created the DAP with the built in wizard. Can someone please help?
>
>
>

more importantly; you shouldn't ever display that many records all at
once

learn to do some filters on the data source control.