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?

Can this be done via a Macro?