Hello,
I have a split database and am preparing to relocate the backend to a different computer. Problem is that there is a lot of data in fields that are used as link fields that point to a specific location where the backend used to be.
For instance, there are data fields that will have, “C:\Users\<username>\Documents\References\text.txt” And there are at least 5 different tables that I need to do this to.
I can use Find and Replace to change this once, but I will most likely have to do this a few times as I’m testing to make sure all works beforehand.
Is there any example of a macro that will do this with a button? For example, It would have to use Find and Replace in a few tables for “C:\Users\<username>\ Documents\References\” and replace it with “F:\References\”
Thanks for any suggestions.
I have a split database and am preparing to relocate the backend to a different computer. Problem is that there is a lot of data in fields that are used as link fields that point to a specific location where the backend used to be.
For instance, there are data fields that will have, “C:\Users\<username>\Documents\References\text.txt” And there are at least 5 different tables that I need to do this to.
I can use Find and Replace to change this once, but I will most likely have to do this a few times as I’m testing to make sure all works beforehand.
Is there any example of a macro that will do this with a button? For example, It would have to use Find and Replace in a few tables for “C:\Users\<username>\ Documents\References\” and replace it with “F:\References\”
Thanks for any suggestions.