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