Create or change a security account password
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
A security account password is created to make sure that no other user can log on using that user name. By default, Microsoft Access assigns a blank password to the Admin user account, and to any new user accounts you create in your workgroup.
Start Microsoft Access by using the workgroup the user account is stored in, and log on using the name of the account for which you want to create or change the password.
You can find out which workgroup is current or change workgroups by using the Workgroup Administrator.
Open a database.
On the Tools menu, point to Security, and then click User And Group Accounts.
On the Change Logon Password tab, leave the Old Password box blank if a password hasn't been defined previously for this account. Otherwise, type the current password in the Old Password box.
Type the new password in the New Password box.
A password can range from 1 to 20 characters, and can include any characters except ASCII character 0 (null). Passwords are case-sensitive.
Retype the password in the Verify box, and then click OK.
Caution You can't recover your password if you forget it, so be sure to store it in a safe place. If you forget your password, a user logged on with an administrator account (a member of the Admins group in the workgroup in which the account and password were created) must clear the password before you can log on.