Solved

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

Posted on 2013-06-07
7
356 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 82

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 82

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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 82

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

707 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

18 Experts available now in Live!

Get 1:1 Help Now