Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

DAP-Only displays 10,000 records

Discussion in 'Information Technology' started by AceWill, Jul 28, 2006.

  1. AceWill

    AceWill
    Expand Collapse
    Guest

    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?
     
  2. Loading...

    Similar Threads Forum Date
    Arts/Society SGPC displays rare historic treasure in Golden Temple Language, Arts & Culture Jun 12, 2010
    Sikh News Search.com displays degoratory and offensive material on Sikh Guru Breaking News Dec 31, 2006
    Sikh News When displays of faith spark fear (Milford Daily News) Breaking News Sep 12, 2006
    Christianity Appeals on Commandments Displays Rejected (AP via Yahoo! News) Interfaith Dialogues Jun 29, 2005
    Christianity Museum Displays Pocahontas' Earrings (Newsday) Interfaith Dialogues Jun 13, 2005

  3. Ken Snell \(MVP\)

    Ken Snell \(MVP\)
    Expand Collapse
    Guest

    Check the MaxRecords property of the page.

    --

    Ken Snell
    <MS ACCESS MVP>

    "AceWill" <AceWill@discussions.microsoft.com> wrote in message
    news:F9C8B8E1-03AE-40DB-A030-A764C39DDE2F@microsoft.com...
    > 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?
     
  4. AceWill

    AceWill
    Expand Collapse
    Guest

    Duh! Thank you so much!

    "Ken Snell (MVP)" wrote:

    > Check the MaxRecords property of the page.
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "AceWill" <AceWill@discussions.microsoft.com> wrote in message
    > news:F9C8B8E1-03AE-40DB-A030-A764C39DDE2F@microsoft.com...
    > > 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?

    >
    >
    >
     
  5. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

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

    learn to do some filters on the data source control.
     

Share This Page