Updating Access ODBC connections using VBA
I don’t do much in Access or VBA but sometimes you inherit things that force you, at least temporarily, to go retro.
We have an Access-based data extraction routine that uses several (21) pass-through queries that use an ODBC connection. The queries are pulling data from an Oracle database maintained by a different agency that enforces a time-out of passwords every three months.
So every three months I have to go through the ODBC connections for these queries and change the password.