Edit

ALTER USER or DATABASE statement (Microsoft Access SQL)

  • Article

Applies to: Access 2013, Office 2013

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

Syntax

ALTER DATABASE PASSWORD newpassword oldpassword

ALTER USER user PASSWORD newpassword oldpassword

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.