Using VB.NET update location of Linked tables in an Access MD

[Don Glover - doppelganger]

My goal is to read the list of linked tables, validate that the link is correct, and (if it isn't) update the the mdb file.
I can retrieve the list of linked tables,

restrictions(3) = "Link"
con.Open()
' Get list of user tables
userTables = con.GetSchema("Tables", restrictions)
con.Close()

From that can I get the linked file/table info and can I modify the link if it wrong?

Continue reading...