ACC95: Database Password That Contains a Space Becomes Invalid After Compact

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new, blank Microsoft Access 7.0 database.
2. Create a database password for the new database. To do so, follow these steps:
   
   
   1. Close the database.
   2. On the File menu, click Open Database.
   3. Click the Exclusive check box, and then open the database.
   4. On the Tools menu, point to Security, and then click Set Database Password.
   5. In the Password box, type this password: New Password. Be aware that passwords are case-sensitive.
   6. In the Verify box, confirm your password by typing the password again, and then click OK.
   The password is now set. The next time you or another user opens the database, a dialog box will be displayed that requests a password. (Remember that a password is case-sensitive; you must type it exactly as defined.)
3. Close the database and reopen it. When prompted, type the database password: New Password. The database will open without any problems.
4. Close the database again. On the Tools menu, point to Database Utilities, and then click Compact Database. Select the new database in the "Database To Compact From" dialog box, and type the password when prompted. Select the same database name in the "Compact Database Into" dialog box, and click Yes to "Replace existing file" prompt.
5. Open the database and try to use the password: New Password. Note that you receive the following error message:
   
   "Not a valid password"
   
   Click OK and try again. This time use the password: New.
6. Note that the database will open because Microsoft Access removed all characters in the password after the word "New" when the database was compacted.