Community archive

Ask something
Discussion Locked

MS Project 2000

0 helpful
3 replies

by dnanton

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

when using a central database (SQL Server) to centralize the depts projects, how can I:
1. eliminate a hanging connection (where it says that the project is read-only for everybody else, than the lost connection I had.
2. how to avoid that only 1 person at a time can update the project.
3. how to interact project with Lotus Notes, so it can send messages through notes, and todo's as well.

thanks,
daniel nanton.
costa rica.

3 replies

by el flush san

I can answer to 1 and 3 above.

3 first. We have been unable to successfully implement P2K with Notes even though Notes 5 is supposedly MAPI compliant. It seems to work very well with Outlook for mail and calender services though!

1. When project file is terminated abruptly there are indicator fields within the SQL db/table that are flagged. Follow these steps and you should be ok:

Using Enterprise Manager in SQL go to the relevant database, select the table where plan is saved; right-mouse on 'MSP_Projects', 'Open table' then select 'Return all rows'. Select the project that you have issues with, scroll to the end of line (END will do this); MAKE SURE
Proj_Lock, Proj_Read_Only, Proj_Read_Write ARE ALL SET TO 0 (zero).

Click on the Exclamation mark (RUN) and then close Enterprise Manager.

This discussion is closed to new replies.