Change path linked table ms access

Question

I have 2 database that to be used in an application copy them from the server on the user’s local machine. Between these two banks I have a linked table, I need that when I copy to the local machine, update the address of this linked table.

I saw some forums with Vb but found nothing with c#, only VBA...

https://www.scriptbrasil.com.br/forum/topic/160138-resolvido-codigo-vba-para-definir-path-das-tabelas-vinculadas/

Answer 1

// the following code requires that the project have a COM reference to:
// "Microsoft Office 14.0 Access Database Engine Object Library"

// create the DBEngine object
var dbe = new Microsoft.Office.Interop.Access.Dao.DBEngine();

// open the local database file containing the linked table
Microsoft.Office.Interop.Access.Dao.Database db = dbe.OpenDatabase(fileNamePainelGerencialTo);

// create a TableDef object for the linked table we want to update
Microsoft.Office.Interop.Access.Dao.TableDef tbd = db.TableDefs["tblPendencia"];

// update the .Connect property with the full path to the remote database
tbd.Connect = ";DATABASE=" + fileNamePainelGerencialPendenciasTo;

// refresh the table link
tbd.RefreshLink();

// create a TableDef object for the linked table we want to update
tbd = db.TableDefs["tblPendenciaBaixa"];

// update the .Connect property with the full path to the remote database
tbd.Connect = ";DATABASE=" + fileNamePainelGerencialPendenciasTo;

// refresh the table link
tbd.RefreshLink();