I am trying to develop Data Access Pages (DAP) within Access 2003,
specifically using Pivot Table Lists. When creating pivot tables as
forms, all of my records in a table consisting of over 18,000 records
are represented, however, when using pivot tables on a DAP, or even
without using pivot table, only the first 10,000 records are
represented. Is there a limitation of only 10,000 records, or is there
something else that can be adjusted for all of my records to be
represented?
Thanks,
Dave
specifically using Pivot Table Lists. When creating pivot tables as
forms, all of my records in a table consisting of over 18,000 records
are represented, however, when using pivot tables on a DAP, or even
without using pivot table, only the first 10,000 records are
represented. Is there a limitation of only 10,000 records, or is there
something else that can be adjusted for all of my records to be
represented?
Thanks,
Dave