Override Microsoft Access ADPs Showing
Only 10k Records, By Clicking on Icon and Entering 0
Provided by: 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
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.
Return to the tips page