Dynamically updating linked tables in template

[Bronte1226]

I have a template for a small database which my users use to create new personal databases with. The database is stored (both FE and BE) in one folder which the users copy and paste renamed to a new location. The problem is, when they open the new copy, the linked tables are still looking for the tables in the original place/database. Most of the time this is on a completely different system so the path is invalid. Is there a way to dynamically update these links automatically for the new location? (the folder location) My users get confused when the error arises and they have trouble trying to update it themselves. (I don't want to have to do this manually for each and every user each and every time they make a new database from this template) Any ideas would be appreciated! Thanks.

 

[willir]

To answer the question why, Access stores the absolute reference for the linked files. I wish they would allow relative links instead. There are a lot of developers who would appreciate this I am sure.

There is code floating around in the Access forums to relink tables using VBA. You should be able to come across it by searching.