Force Password Change for Db Users

[Blindability]

Hi all

Is there a way to force a user to change their default (admin set) password on a Db?

TIA

[CJ_London]

yes - using vba code

what that code will look like depends on your current routine - you would need some sort of flag to indicate who set the password - admin or user - to trigger the code. In English, something like

while passwordisAdminSet
        routine to change password
        if passwordchange successful then passwordisAdminSet=false
    wend