Solved

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

Posted on 2013-06-07
7
367 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 85

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 85

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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 85

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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

615 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