Prev: Macros Disabled
Next: Project Printing Issues
From: Digman on 27 Jan 2010 11:36 Can anyone tell me if there is a limitation on the number of tasks that can be assigned as predecessors to a single task (single task with multiple predecessors)? I am trying to import from MS-Access. I am finding that the predecessors are being truncated (looks like 255 characters limit). I tried cutting and pasting the predecessors in manually, but still seems to be truncating them. I am trying to paste in 150 tasks as predecessors (4 characters per task plus the comma). I am using MS-Project 2007. The reason I have so many preds. is because I believe I should avoid using Summary tasks as predecessors (this would reduce the amount considerably). -- Dave
From: JulieS on 27 Jan 2010 11:46 Hello Digman, Yes, the field is limited to 255 characters. You are correct in your assessment that using summary tasks in predecessor/successor relationships is not a "best practice." However, as an alternative, consider placing milestones in your project to mark the end of a summary task phase. You can link the appropriate tasks within the summary group to the milestone and then set the milestone task as a single predecessor to other tasks. I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 1/27/2010 11:36 AM, Digman wrote: > > Can anyone tell me if there is a limitation on the number of tasks that can > be assigned as predecessors to a single task (single task with multiple > predecessors)? > > I am trying to import from MS-Access. I am finding that the predecessors > are being truncated (looks like 255 characters limit). I tried cutting and > pasting the predecessors in manually, but still seems to be truncating them. > > I am trying to paste in 150 tasks as predecessors (4 characters per task > plus the comma). I am using MS-Project 2007. > The reason I have so many preds. is because I believe I should avoid using > Summary tasks as predecessors (this would reduce the amount considerably). >
From: Jim Aksel on 28 Jan 2010 01:01 The Project Spec says there is no limit to the number of predecessors or successors to a task. There is a 255 character display limitation in the predecessor/successor columns. To include "unlimited" predecessors, you will need to add them either programatically or on the predecessors tab of the Task Information Dialog box. Predecessors and successors are part of the TaskDependencies collection of a task: Dim t as task t.TaskDependencies (etc) -- If this post was helpful, please consider rating it. Jim Aksel, MVP Check out my blog for more information: http://www.msprojectblog.com "Digman" wrote: > > Can anyone tell me if there is a limitation on the number of tasks that can > be assigned as predecessors to a single task (single task with multiple > predecessors)? > > I am trying to import from MS-Access. I am finding that the predecessors > are being truncated (looks like 255 characters limit). I tried cutting and > pasting the predecessors in manually, but still seems to be truncating them. > > I am trying to paste in 150 tasks as predecessors (4 characters per task > plus the comma). I am using MS-Project 2007. > The reason I have so many preds. is because I believe I should avoid using > Summary tasks as predecessors (this would reduce the amount considerably). > > -- > > Dave
From: HansH on 28 Jan 2010 05:25 Theoretically, there is no limit... In the real world, you are stuck with the 255 character limit. Especially if you are using Project Server. I have seen file corruption because the database also is limited to 255 characters for storing predecessors. This was in version 2003... I'm not sure if it still applies to Project Server 2007. But my advice is to re-organize your plan using the tips from JulieS. Using too many predecessors impacts the readability and manageability of your plan. Kind regards, Hans Projectopolis <http://msepm.hsquared.be> Jim Aksel wrote: > The Project Spec says there is no limit to the number of predecessors or > successors to a task. > > There is a 255 character display limitation in the predecessor/successor > columns. > To include "unlimited" predecessors, you will need to add them either > programatically or on the predecessors tab of the Task Information Dialog box. > > Predecessors and successors are part of the TaskDependencies collection of a > task: > Dim t as task > t.TaskDependencies (etc) >
From: Digman on 28 Jan 2010 08:41
Thanks all - Very helpful! -- Dave "HansH" wrote: > Theoretically, there is no limit... > In the real world, you are stuck with the 255 character limit. > Especially if you are using Project Server. > I have seen file corruption because the database also is limited to 255 > characters for storing predecessors. > This was in version 2003... I'm not sure if it still applies to Project > Server 2007. > > But my advice is to re-organize your plan using the tips from JulieS. > Using too many predecessors impacts the readability and manageability of > your plan. > > Kind regards, > Hans > > Projectopolis <http://msepm.hsquared.be> > > > Jim Aksel wrote: > > The Project Spec says there is no limit to the number of predecessors or > > successors to a task. > > > > There is a 255 character display limitation in the predecessor/successor > > columns. > > To include "unlimited" predecessors, you will need to add them either > > programatically or on the predecessors tab of the Task Information Dialog box. > > > > Predecessors and successors are part of the TaskDependencies collection of a > > task: > > Dim t as task > > t.TaskDependencies (etc) > > > |