Changing a password in an Access project

If your Microsoft Access project (.adp) is connected to a Microsoft SQL Server 6.5 (or later) database with SQL Server security implemented, then you can change the logon password from within Access.

1. Open an Access project file or switch to the Database window for the open project.
2. On the Tools menu, point to Security, and then click Set Login Password.
3. In the Old Password box, type the current password.
4. In the New Password box, type your password.

   Guidelines for passwords

   User names can range from 1 to 20 characters, and can include alphabetic characters, accented characters, numbers, spaces, and symbols, with the following exceptions:

   • The characters " \ [ ] : | < > + = ; , . ? *
   • Leading spaces
   • Control characters (ASCII 10 through ASCII 31)

   Note   Passwords are case-sensitive.

5. In the Verify box, confirm your password by typing the password again, and then click OK.

   The password is now changed and Access resets the .adp connection with the new password information. The next time you or any other user opens the project, a dialog box will be displayed that requests the new password.

Important   If you lose or forget your password, it can't be recovered, and you won't be able to open your project.