Hello everyone. I have a little issue and I'm not sure what the best approach is to fix it. I've built a rather robust database that needs to be idiot proof. Chances are after I leave there will be little to no back-end maintenance on it. There are hyperlinks throughout the database as well as a few lines of code that reference network locations that could change 1-2 years down the line. What I need to do is build a "housekeeping" form that is password protected where users can edit those hyperlinks via text-boxes. My problem is I'm not sure where to store the the data from the text-boxes to make it persistent. Making a table for the hyperlinks seems to be the wrong approach but I could be wrong.
Example:
Form1-Button1="String1"
String1="HousekeepingForm-TextBox1"
HousekeepingForm-TextBox1="X:\Stuff"
Example:
Form1-Button1="String1"
String1="HousekeepingForm-TextBox1"
HousekeepingForm-TextBox1="X:\Stuff"