CCIG2006
asked on
Change table link in MS Access using VBA
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.
There is a rush on this question, so I give 500 points.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome! Thanks!!!
No probs
http://www.mvps.org/access/tables/tbl0009.htm