Auto Fixing Links in module

[Steven547]

Hey guys. We are currently using a program called Linksfix (or something like that). It is supposed to correct any broken links in a lot of programs. It should do it for Access, but the support guy says it might not be supported yet for modules. Is there a way or another program that will do this?

The problem is, and it might not be a problem, but in the module:
This is the module code (functions), and obviously I've only included the main lines of code for each function...In this module, there are 3 functions, shown in order they are run:

1----- Function.....

Path = Module1.Drive_Path() & Module1.DB_Directory() & "Statement Events\Tracker_Archieve\"

File_Name = "tracker_MidMonth.txt"

2----- Function Drive_Path() As String

Drive_Path = \\Brofs3\Teams1\Departments\PIMS\State Street Conversion\

3----- Function DB_Directory() As String

DB_Directory = "Oversight Roles and Responsibilities\Statement Review\"

After looking at that code, I gather this is the path created:

\\Brofs3\Teams1\Departments\PIMS\State Street Conversion\Oversight Roles and Responsibilities\Statement Review\Statement Events\Tracker_Archieve\

However some of those paths are wrong and need fixed...is there a program to look into an .mdb and change those paths automatically? Otherwise, i'll have to do this for 180+ mdbs. (Job security I guess!)

 

[Remou]

Yes, it is possible to replace all occurrences of a string in code in multiple databases. You may wish to look at the code here:

http://www.tek-tips.com/viewthread.cfm?qid=1458874&page=2

and also here

http://wiki.lessthandot.com/index.php/More_VBE.

I suggest that you replace with a reference to a field in a "system details" table, so this does not happen again.