Relink tables

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
C

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.
 
ChoonBoy said:
I have a split FE / BE Access 2007.
Click to expand...

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.
Click to expand...

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/
 
ChoonBoy said:
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.
Click to expand...

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/
 
Back
Top