Are you talking about changing a variable from one front end and having that change the same variable in every other front end that's hitting the database? The best way to do that is to create a "control" table that contains a single row. Each field in that table is a single, application-wide value that needs to be dynamic and available to all users.
Something totally different. What I want to do is equivalent to right clicking on "My Computer", going to properties, select the "Advanced" tab, clicking the "Enviornment Variables" button and setting a variable/path.
Here is some code that I found on MSDN that retrieves the environment PATH variable but I want to know if I can set the variable.
Dim EnvString, Indx, Msg, PathLen ' Declare variables.
Indx = 1 ' Initialize index to 1.
EnvString = Environ(Indx) ' Get environment
If Left(EnvString, 5) = "PATH=" Then ' Check PATH entry.
PathLen = Len(Environ("PATH")) ' Get length.
Msg = "PATH entry = " & Indx & " and length = " & PathLen
Indx = Indx + 1 ' Not PATH entry,
End If ' so increment.
Loop Until EnvString = ""
If PathLen > 0 Then
MsgBox Msg ' Display message.
MsgBox "No PATH environment variable exists."