ALTER USER or DATABASE Statement

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013

Changes the password for an existing user or for a database.

Syntax

ALTER DATABASE PASSWORD newpasswordoldpassword

ALTER USER user PASSWORD newpasswordoldpassword

The ALTER USER or DATABASE statement has these parts:

Part	Description
user	The name of a user to be added to the workgroup information file.
newpassword	The new password to be associated with the specified user or database name.
oldpassword	The existing password to be associated with the specified user or group name.