Contents
To do this, follow these steps: 1 In Access, select File > Options. 2 Select Current Database. 3 Scroll down to the Caching Web Service area, and then locate the Microsoft SharePoint tables. 4 Make sure the Use the cache format that is compatible with Microsoft Access 2010 and later check box is selected. More
Where do I find access in linked table manager?
If you have many linked tables, use the Search box at the top of the Linked Table Manager dialog box to find what you want. Enter text in the Search box. Access searches the Data Source Name and Data Source Information columns to find a match.
How to change the name of a linked table?
Whether or not Access locates the data source, Access prompts you for a new data source location. After you enter the correct location, you can either keep the existing linked table names unchanged or choose new table names. Make sure the Status column is visible (you may have to scroll sideways), and then check it to see the results:
How to check the status of a linked table?
Expand (+) entries in the Data Source to select individual linked tables. Select Refresh. If there is a problem with the data source location, enter the correct location if you are prompted or Edit the data source. Make sure the Status column is visible (you may have to scroll sideways), and then check it to see the results:
Here’s the specific problem I experienced: I used the “Move To SharePoint” command from Access to link the database to SharePoint. It created the appropriate lists on the SharePoint site, and in Access those now show up as linked tables (the icon is gold).
What happens when you link to a SharePoint list?
When you link to a SharePoint list, Access creates a new table (often referred to as a linked table) that reflects the structure and contents of the source list. Unlike importing, linking creates a link only to the list, not to any specific views of the list.
If you’re using Microsoft 365 or Access 2019, on the External Data tab, in the Import & Link group, click New Data Source > From Online Services > SharePoint List.