SharePoint Document Issues

Fix Access Showing Only 1,000 Records from a SharePoint List

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

An Access table linked to a SharePoint list displays fewer records than the list contains.

Access Shows Only 1,000 Records from a SharePoint List
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.
Before you start

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.

Solution 1Recommended

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.

1
Check for filters

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.

2
Review the linked table

In Access, open External Data > Linked Table Manager and check that the table points to the intended SharePoint site and list.

3
Test a new link

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.

4
Compare Access versions

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.

Check the SharePoint link and test it in a current Access version
Results can vary by environment: One test in Access for Microsoft 365 did not reproduce the issue reported in Access 2019. This does not establish a universal 1,000-record limit or guarantee that changing versions will fix the link.
Free Microsoft Office alternative

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.

Review list data in a familiar spreadsheet interfaceOpen and edit Microsoft Excel XLSX filesMove existing Office documents into a lightweight workspaceUse a free Office alternative for everyday document tasks
microsoft office alternative - wps office

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.