Move from Novell to Win2003 Net/ Linking

[m miller]

Our corp. is going to move from a Novell Network to a Windows 2003 network.
All the server names will change.
The problem is our users Link Tables and other references to Network UNC
paths (macros, etc.). We have literally
hundreds of end-user MS Access databases and no idea as to who 'links' to
what.

Is there any possible way to identify these paths in an Access .mdb file
programmatically and also change them
programmatically?

Input is greatly appreciated.

Marc Miller
CTE

 

[Tony Toews]

Our corp. is going to move from a Novell Network to a Windows 2003 network.
All the server names will change.
The problem is our users Link Tables and other references to Network UNC
paths (macros, etc.). We have literally
hundreds of end-user MS Access databases and no idea as to who 'links' to
what.

Is there any possible way to identify these paths in an Access .mdb file
programmatically and also change them
programmatically?

Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm
will give you the starting point.

However can you update those links from an external program? That I'm
not sure at all.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm