Microsoft 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 Microsoft Access/Jet database (.MDB or .ACCDB) 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.
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.