none
Refreshlink AWS RRS feed

  • Question

  • I have an Access table that is linked to a AWS table. I didn't set this up, the consultant who did is gone. I need to Refreshlink the table on a Form load. I can run the code below to RefreeshLink on my P.C. but it doesn't work on the Access table that is linked thru the AWS table. It might be because AWS isn't done thru a DAO connection(Sharepoint)? In Linked Table Manager the Data Source Name is Sharepoint and the Data Source Information is Https://......

    This is the code I used.

    Dim db2 As DAO.Database
    Set db2 = CurrentDb

    Dim tdf1 As DAO.TableDef
    Set tdf1 = db2.TableDefs("AccessLinkedTable")
    tdf1.RefreshLink

    Wednesday, December 11, 2019 4:30 PM