Change table link in MS Access using VBA
Posted on 2006-07-13
I know how to get the link from a table to a table in another database, but I don't know how to change it. Example, a table links to a table in "C:\Data\Old\Database.mdb" and I want it changed to "D:\Data\New\Database.mdb". Due to the number of tables & links involved, I need it done via code instead of the manual process. It would have to be looped for each table found in a database without having to specify the table (link) names.
There is a rush on this question, so I give 500 points.