I have found a solution that I have adopted in my solution.
public void UpdateLinkedTablesConnectionString()
{
try
{
string currentAssemblyDirectoryName = System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
StringBuilder strPath = new StringBuilder();
strPath.Append(currentAssemblyDirectoryName);
strPath.Append(Common.GetResourceValue(_directory_DataInput, false, null));
strPath.Append(Common.GetResourceValue(_excelFileName, false, string.Empty));
ADODB.Connection Con = new ADODB.Connection();
Con.ConnectionString = myAccessDatabase.ConnectionString;
ADOX.Catalog Cat = new ADOX.Catalog();
Con.Open();
Cat.ActiveConnection = Con;
List<string> lstLinkedTablesNames = GetTablesNames();
foreach (string name in lstLinkedTablesNames )
{
Cat.Tables[name].Properties["Jet OLEDB:Link Datasource"].Value = strPath.ToString();
}
Con.Close();
}
catch (Exception exception)
{
throw exception;
}
}