Access 2007 - Changed ODBC connection information - queries not changed
Posted on 2014-03-21
We had a group in the organization who was using a heavily-modified TNSNames.ORA and a significant number of non-conforming ODBC DSNs. We are continuing to support this in the short-term until we can resolve this issue.
The group uses a number of Access 2007 databases which have queries pointed to legacy TNSNames.ORA entries. I have updated the table ODBC links, but this does not apparently make changes to the links the queries are using. There are hundreds, if not thousands, of queries per Access database file.
How can I programmatically, or via the Access 2007 GUI, change these query definitions without having staff delete and recreate the queries?