Oracle's 8i and newer ODBC drivers support changing passwords; when a password has expired (from an Oracle profile setting), the ODBC driver displays a dialog box with one old password prompt and two new password prompts. Note: - may get an application error since the new password is not passed back to the application (may need to have user login again using their new password). Web page note: need to be careful in coding the password reset routine to prevent users from changing other user passwords (e.g. system). Have Fun :) > We have implemented the password change mechanism in our own = application. > Our problem is that we have many users using ACCESS or = EXCEL via ODBC to > connect to the database. ACCESS and EXCEL do not habe = a password change > mechanism implemented. The user only get an ORA- error = when connecting to > the database. > -- //www.freelists.org/webpage/oracle-l