Task (milestone) name changing outline level ???

[Lorveney]

Hi,

I am just completing an Access database enhancement to export milestones to
Microsoft project (using office automation in VBA).

I am exporting the milestones at outline level 3, these are owned by
projects at outline level 2 and programmes at outline level 1.

This is working OK except one particular milestone which should be level 3
is being imported as a level 2 (project).

The milestone has the name: BRS Signed Off

If I change it to, say, B RS Signed Off or XBRS Signed Off or Signed Off it
works OK (i.e. comes in as level 3).

Also, if I change the order the milestones are entered so this is the second
level 3 for the project instead of the first, it again works OK.

It's almost as if the 'BRS' is acting as some 'translator code' in MS Project.

Anyone any ideas a) what is causing it and b) how to circumvent it?

Thanks

 

[Lorveney]

Hi,

On further examination this may be 'red herring'.

I suspect it is more about its relative position in the table as when I
reduce the number of records being exported it is OK, as is.

This is actually a bit concerning as the dates are also being treated
differently depending on its table position.

I suspect that rather that reading and processing the records individually
through DAO I may have to revert to using the MapEdit/FileOpenEX methods.