Menu
I have two tables linked with sharepoint lists. And I have a form in access db, each time when the form loads the table which is linked to sharepoint list should refresh automatically.
Is there ant way to do this in vba code?
I'm using
Application.DoCmd.TransferSharePointList acLinkSharePointList
969
Structural changes made to a SharePoint list are not automatically reflected in a linked table. To update a linked table by applying the latest list structure, right-click the Access table in the Navigation Pane, point to More Options, and then click Refresh List.
From the menu that opens, select SharePoint or Teams, and then select the site with the files you want to sync. Select Documents or navigate to the subfolder you want to sync. Select Sync. (You only need to do this once on a computer to set up syncing on that computer.
Access 2010/2013/2016/2019 and Access Services gives a platform to make databases that you can use on the SharePoint site. Using an Access database and Access services you can design/publish a web database. Users who are already having an account on the SharePoint site can make use of the web database in a web browser.
Use CurrentDb.TableDefs("TableName").RefreshLink (replace TableName with your actual table name).
55
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
