DevOps, CI/CD and Automation

I have a MS Access based application using Oracle 8i as
a back end database. The application uses ODBC to connect
to the database using Oracle user credentials (UserID and Password).

When new users are added, the DBA sets an initial password that is expired, so the user must change it the first time they attempt to log in. My user community is not very computer literate (i.e I can't tell them to first try to log in using SQLPlus - they won't know what I'm talking about). I need to provide a password change facility within the MS Access application.

I've already created a form to do so. It contains logic to make sure blank passwords are not entered, and that the new password is verified prior to sending an ALTER USER command to the Oracle database.

My problem is with the expired passwords. When I attempt to connect using an expired password using ODBC, the VBA script detects the password expired error and refuses the connection. Needless to say, the password change can't happen after that. Is there a way to do this?

I can post my code if necessary, but I'd rather not since my customer is extremely sensitive about this application.

Any help would be greatly appreciated!