Web Analytics Made Easy -
StatCounter

Node Dangles

pass-through query

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.
Menu