<div>
<div class="content wysiwyg-content">
I am using Access 2016 MDB file with VBA and Links to Share Point Foundation Lists.<br />
When I REFRESH the SPF list via selecting the list and right mouse more options &quot;Refresh List&quot; in access it updates fine.<br />
In VBA the only option I can find is to RefreshLink, this disassociates the link from the custom group in the Navigation pane and creates a new ID.<br />
Currently I have code that reads and writes the MSys tables to put back the Linked table in the appropriate &nbsp;Hidden Custom group.<br />
My preference is not to have to read and write the MSys tables.
</div>
</div>


I am using Access 2016 MDB file with VBA and Links to Share Point Foundation Lists.
When I REFRESH the SPF list via selecting the list and right mouse more options "Refresh List" in access it updates fine.
In VBA the only option I can find is to RefreshLink, this disassociates the link from the custom group in the Navigation pane and creates a new ID.
Currently I have code that reads and writes the MSys tables to put back the Linked table in the appropriate  Hidden Custom group.
My preference is not to have to read and write the MSys tables.

Refreshing Share Point Foundation Lists in Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.