M
MNorwood
We are using MS Project 2000 and using SQL Server 2000 to
store the project data. When we try to open a project we
the following error:
"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."
I followed "Microsoft Knowledge Base Article - 302937
PRJ2000: Message States the File Is Locked or in Use When
You Try to Open a Project" and did as recommended in the
Resolution section.
RESOLUTION
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.
But, it did not help.
Thanks
Michael Norwood
(e-mail address removed)
store the project data. When we try to open a project we
the following error:
"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."
I followed "Microsoft Knowledge Base Article - 302937
PRJ2000: Message States the File Is Locked or in Use When
You Try to Open a Project" and did as recommended in the
Resolution section.
RESOLUTION
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.
But, it did not help.
Thanks
Michael Norwood
(e-mail address removed)