|
Free Resources from FMS |
|
|
|
|
"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - Darren D. |
|
|
|
|
Microsoft
Access Resource Center
Override ADP Showing Only 10k Records, By Clicking on Icon and Entering 0
Provided by: Steve Clark, Senior Project Manager
Access Data Projects (ADPs) let you efficiently connect to SQL Server
databases. When viewing an ADP table, all its records may not be displayed.
Viewing a table in a regular Access/Jet database (.MDB) always displays all
the records, but by default, ADPs only display the first 10,000 records. In most
cases this is fine since many tables are smaller than this. However, you may
need to show more or all the records.
This can be set with a table property. With your table open, from the main
menu choose: Records / Maximum Records... . This opens a dialog box to enter
the desired number of records. Enter 0 to display all the records. Be
careful with the 0 setting because it will take time if your table contains
hundreds of thousands or millions of records.
