Override Microsoft Access ADPs Showing Only 10k Records, By Clicking on Icon and Entering 0

Provided by the FMS Development Team

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.