Relative Content

Tag Archive for vbams-accessdataverseexternal-links

Refreshlink on Dataverse table from Access Database not working

I have a button on an Access form that calls the subroutine below. The database has external links to Dataverse tables. The idea of the routine is to refresh the links to the Dataverse tables and then refresh the form. The subroutine completes normally, and the “Tables Refreshed” message appears without error. However, the tables are not actually refreshed. The last table is called tblProjectsDataverse and contains project descriptions from the table which then appear in a list on the form. After I run the routine, I manually open the linked table (tblProjectsDataverse) and new projects added from a different source to the Dataverse table are not included. If I manually run Refresh Links by right clicking the linked table on the Navigation pane and selecting Refresh Links, the table is updated correctly. I don’t know why the .RefreshLink method in VBA would work differently than Refresh Link manually.