Solved

Update Links in Office Docs Pointing to an Old File Server (UNC)

Posted on 2013-06-07
7
357 Views
Last Modified: 2013-08-25
Hello,
One of my customers is using Excel docs to reference other files relating to a specific case via links created inside the Excel doc. The link point to \\oldserver\publicstorage\etc\etc. I am planning to move the cases folder to a new server with larger storage over the weekend, which means that those links will stopped working. The new address will be \\newserver\cases\etc\etc.

 Is there a way to create a link between the two addresses so that all those hundreds on links/ files will not need to be updated manually?

Thanks for your help.
0
Comment
Question by:SpiderPig
  • 4
  • 3
7 Comments
 
LVL 83

Expert Comment

by:oBdA
ID: 39229798
On the new server, create the "DisableStrictNameChecking" key as described here (yes, it's still valid for 2008):
Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name
http://support.microsoft.com/kb/281308
Then once the data is on the new server, either
* rename the old server if you still need it, or
* shut the old server down for good and delete the old computer account from AD.
Then you can create a new static DNS host entry with the old server's name and the new server's IP address.
0
 

Author Comment

by:SpiderPig
ID: 39229815
O.K so both servers will remain active for another 2-3 years... Does that change anything? What is DisableStrictNameChecking? Where is it?
0
 
LVL 83

Expert Comment

by:oBdA
ID: 39229869
The "DisableStrictNameChecking" is in the registry as described in the link above. It allows a server to respond to requests made for a name other than its host name.
So you can either
* move everything that absolutely requires to be found under the old server's name and shares onto the new server, rename the old one, and then create the static DNS entry (or, of course, rename the new server to the old server's name if that's an option), then change anything that still requires access to the old server to point to the new name of the old server, or
* Keep the old server with its original name, and create a script that automatically opens all Excel files and replaces the occurrences of the old name with the new one.
Seeing as you want to do this pretty soon, you won't have enough time to reliably develop and test the script required for the latter.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:SpiderPig
ID: 39230028
Not to mention how to do something like that... blah...

Shoot so no other options for me?
0
 
LVL 83

Expert Comment

by:oBdA
ID: 39230124
None that I can think of, sorry; you can't just redirect a shared folder to another shared folder in the way required for your scenario.
If it's just about storage space (and not the general performance of the old server), you could attach more "real" storage to the old server and then mount the additional storage as the "Cases" folder.
0
 

Accepted Solution

by:
SpiderPig earned 0 total points
ID: 39425026
I guess I was dealing with relative links, which didnt include specific server name but rather a ...\ file or something strange like that. So when I move the files the links for updated auto. Not sure how but it worked, but it did.

Thank you all for the prompt response and my apologies for the delay.
0
 

Author Closing Comment

by:SpiderPig
ID: 39436759
None of suggested solutions worked. At the end a simple robocopy (robocopy source destination *.* /COPYALL /DCOPY:T /E) worked.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now