Fix Access Showing Only 1,000 Records from a SharePoint List
Question details
An Access table linked to a SharePoint list displays fewer records than the list contains.

- Product
- Microsoft Access 2019 and SharePoint
- Device & OS
- not provided
- Scenario
- The user wants to view all records from a SharePoint list in a linked Access table.
- Observed behavior
- The linked table shows only 1,000 records even though the SharePoint list contains more than 23,000.
Check the total number of items in the SharePoint list and note whether the view has filters applied. In Access, open File > Account to identify your Office version and update status.
Check the SharePoint link and test it in a current Access version
Use this approach to rule out a filtered view or an incorrectly configured link and compare results across Access versions.
Open the linked table in Access and check the record navigation bar. On the Home tab, use Toggle Filter if a filter is active, and compare the count with an unfiltered SharePoint list view.
In Access, open External Data > Linked Table Manager and check that the table points to the intended SharePoint site and list.
In a test database, choose External Data > New Data Source > From Online Services > SharePoint List. Enter the site address, select the option to link to the data source, and choose the list.
Open File > Account > Update Options > Update Now if available, then check the linked table again. If you have access to Access for Microsoft 365, create or open the link there and compare the record count.

Gather details for Microsoft support or the Access community
Use this option if the linked table still shows fewer records after checking filters and the connection.
Review exported SharePoint list data in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open a locally saved Excel export of your SharePoint list to review the data, though WPS does not repair an Access-to-SharePoint link.

Frequently Asked Questions
Does Access have a universal 1,000-record limit for SharePoint links?
The reported behavior does not establish a universal limit. Check filters, the link configuration, and the Access version, then compare the result in a current version if possible.
How can I check whether the Access table is filtered?
Open the linked table and check the record navigation bar. If a filter is active, use Home > Toggle Filter and compare the displayed count with the SharePoint list.
Where can I find my Access version and build?
In Access, open File > Account and look under Product Information. Select About Access if you need additional version and build details.
Can WPS Office fix the Access link to SharePoint?
No. WPS Office does not repair the Access-to-SharePoint connection. You can use WPS Spreadsheets to review list data saved locally as an Excel XLSX file.




