Changes the password of an existing user account or Microsoft Jet database (Microsoft Jet workspaces only).
Note Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.
Syntax
object.NewPassword oldpassword, newpassword
The NewPassword method syntax has these parts.
Part |
Description |
object |
An object variable that represents the User object or a Microsoft Jet 3.x Database object whose Password property you want to change. |
oldpassword |
A String that is the current setting of the Password property of the User or Jet 3.x Database object. |
newpassword |
A String that is the new setting of the Password property of the User or Jet 3.x Database object. Note Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down. |
Remarks
The oldpassword and newpassword strings can be up to 14 characters long and can include any characters except the ASCII character 0 (null). To clear the password, use a zero-length string ("") for newpassword.
Passwords are case-sensitive.
If object refers to a User object that is not yet appended to a Users collection, an error occurs. To set a new password, you must either log on as the user whose account you're changing, or you must be a member of the Admins group. The Password property of a User object is write-only — users can't read the current value.
If object refers to a Microsoft Jet version 3.0 or later Database object, this method offers some security by means of password protection. When you create or open a Microsoft Jet 3.x .mdb file, part of the Connect connection string can describe the password.
If a database has no password, Microsoft Jet will automatically create one by passing a zero-length string ("") for the old password.
Caution If you lose your password, you can never open the database again.