When you attempt to open a project, you may receive a
message similar to the following:
The project is
currently locked and cannot be opened.
Either another user is saving or
opening the project, or the user has it locked for exclusive use. Try again
later.
As a result, you cannot open the project.
This behavior can occur if you work with a project that is
stored in a database. If some fields in the MSP_PROJECTS table contain
incorrect values, this can cause the file to be locked.
To resolve this issue, you must unlock the file. To do
this, edit the values in the MSP_PROJECTS table by following these steps:
- To view the tables, open the database that contains the
project.
- Set the values in the MSP_PROJECTS table to the following:
PROJ_READ_ONLY = '0'
PROJ_READ_WRITE = '0'
PROJ_READ_COUNT = '0'
PROJ_LOCKED = '0'
PROJ_MACHINE_ID = null
PROJ_EXT_EDITED = '1'
- Close the database.
If you use Microsoft SQL Server to store the project database,
you can modify the following SQL update statement and then use it to unlock the
project:
Update MSP_PROJECTS
Set PROJ_READ_ONLY = '0',
PROJ_READ_WRITE = '0',
PROJ_READ_COUNT = '0',
PROJ_LOCKED = '0',
PROJ_MACHINE_ID = null,
PROJ_EXT_EDITED = '1',
Where PROJ_ID = <YourProjID>
The placeholder <
YourProjID> represents your Project ID.
Microsoft Project supports the following databases through
Open Database Connectivity (ODBC):
- Microsoft Access 2000
- Microsoft SQL Server 7.0 or later
- Microsoft Data Engine 1.0 or later
- Oracle Server, version 8.0 or later
For additional information about how to use Microsoft Project
with databases, view the contents of the Projdb.htm file stored on the
Microsoft Project 2000 compact disc. To do this, follow these steps.
Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
- Insert the Microsoft Project compact disc into your
computer's CD-ROM or DVD-ROM drive.
- Click Start, point to Search, and then click For Files or Folders.
- In the Search Results dialog box, type Projdb.htm in the
Search for files or folders named box.
- In the Look in list, click Compact Disc, and then click Search Now.
- In the Search Results pane, double-click the Projdb.htm file that you want.
Note The MultiLanguage Pack folder contains the Projdb.htm file in
various other languages.
The Microsoft Project 2000 Database Format page opens in your
Web browser.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.