How do I change the IP address on an existing ODBC connection? I am using an Access database that has linked tables. The tables use and ODBC DSN that has an outdated IP address in it.
I looked for an option in the ODBC Data Source Administrator (Control Panel.Administrative Tools.Data Sources Administrator ODBC) but no luck. I can see the name of it on the File DSN tab but the configure button is dithered out. Is there a config file somewhere or a registry key where I could change the IP address associated with that connection?