I have an ODBC connection to my local server which was fine for when I
testing the program.

Now it is time to roll the program out to production,
and I have to change the ODBC on the back end from one SQL database to
another, any suggestions on how to change the ODBC?

Also, can this be done via a Macro?