Change a linked table inside Access


#1

What activity would I use to change the link of a table in Access? My example:

Table A linked to db1.accdb now needs to be linked to db2.accdb

Table has the same name. Only the linked path will change. In Access VB it’d be:

db.TableDefs(strTableName).Connect = “;DATABASE=” & sFile

Is there an equivalent in UIPath? Does someone have an example?

Thanks.