alternative to manually refreshing linked tables?

[WPW07]

Hello,

Not sure where to begin with this. I developed a simple front end
application which is linked to a dozen oracle tables. Everything
worked fine until today. The user received this message: "Microsoft
Office Access" ODBC - Connector to "xxx" failed. I remembered the
password for Oracle expires every 90 days. So I went in and refreshed
the links with the new password.

Is there a way through autoexec and/or vba code to handle this in the
future?

Thank you.