Relink tables

[ChoonBoy]

Appreciate any help to solve this.

I have a split FE / BE Access 2007.

My FE is linked to the BE as well as TextFile1, TextFile2 and TextFile3. All
FE,BE and TextFiles are always in the same location but the Directory name
may change.

I have codes that will only relink to a single BE when the folder name is
changed or the FE and BE are moved to another location
(http://www.databasejournal.com/features/msaccess/article.php/3586401/Automatic-Table-Relinking.htm)

I need codes to relink FE to the BE and all its TextFiles link.

Thanks for you help.

 

[Tony Toews [MVP]]

I have a split FE / BE Access 2007.

Good but ...

My FE is linked to the BE as well as TextFile1, TextFile2 and TextFile3. All
FE,BE and TextFiles are always in the same location but the Directory name
may change.

Each user should get their own copy of the FE MDB/MDE/ACCDE. For more
info on the free Auto FE Updater utility see
http://www.autofeupdater.com to keep the FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Tony Toews [MVP]]

I have codes that will only relink to a single BE when the folder name is
changed or the FE and BE are moved to another location
(http://www.databasejournal.com/features/msaccess/article.php/3586401/Automatic-Table-Relinking.htm)

I need codes to relink FE to the BE and all its TextFiles link.

Take a look at the connect values for tables linked to the textfiles.
It will be somewhat different than
";DATABASE=C:\DataFast\Data\PubsDataC.mdb"
as shown on the above page.

You will then need to update the above refresh code, for those
particular tables, to use the appropriate connect string.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/