ACC: "Run-Time Error '3031': Not a Valid Password" Error Message

MORE INFORMATION

Steps to Reproduce Problem

1. Open the sample database Northwind.mdb exclusively.
2. On the Tools menu, point to Security, and then click Set Database Password.
3. Type FourteenCharac in the Password and Verify boxes.
4. Close Northwind.mdb.
5. Create and open a new database named Test.mdb.
6. In the Database window, Click Modules. Click New, and then type the following code:

       Sub OpenDB()
   
         Dim db As Database
         Dim ws As Workspace
   
         Set ws = DBEngine.Workspaces(0)
   
       ' The default path to Northwind.mdb in Access version 7.0 is
       ' C:\MSOffice\Access\Samples\Northwind.mdb
         Set db = ws.OpenDatabase _
          ("C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb", _
          False, False, "MS Access;PWD=FourteenCharac")
   
         Set ws = Nothing
         Set db = Nothing
   
       End Sub
   					

7. On the View menu, click Debug Window. Type OpenDB, and then press ENTER.

Steps to Remove the Password from Northwind.mdb

1. Open the sample database Northwind.mdb exclusively.
2. Type FourteenCharac in the Enter Database Password box. Click OK
3. On the Tools menu, point to Security, and then click Unset Database Password.
4. Type FourteenCharac in the Password box. Click OK
5. Close the Northwind.mdb database.