My Access Append Quary Update to The Wrong WBS Level?

Rodel Marasigan 👤 Member for 19 years 7 months

Wed, 2007-10-10 03:39 · Permalink

David,

Updating WBS using append query via ODBC is easy as long as you understand the structure of PMDB database and how it works. It’s sits on PROJWBS table and every WBS has a unique WBS_id. You must aware what the proj_id, obs_id and important fields are the seq_num which is the sorting and appearance of your WBS node tree, proj_node_flag that identify whether it is a project or WBS, wbs_short_name is the numbering, wbs_name is the description and the wbs_parent_id where identify which project node it should be under. The rest are self explanatory.

Should you require any assistance please send me a PP with email address so I can guide you on the right path.

Happy to help,

Rodel

David Smith 👤 Member for 18 years 10 months

Tue, 2007-10-09 19:22 · Permalink

Thanks Kieth,

I did end up building the WBS by hand. Will

try to use your recommendation and use an update

query. I am going to learn this stuff yet.

Thanks Again

David

Keith Marsden 👤 Member for 22 years 2 months

Tue, 2007-10-09 18:49 · Permalink

create your wbs in primavera and then use an update query to make them read as you wish. appending is very dodgy if done via the back end as it effectively bypasses primaveras referential integrity rules. dont go there.

Menu

My Access Append Quary Update to The Wrong WBS Level?

Top Posters

Menu

My Access Append Quary Update to The Wrong WBS Level?

Forum Sponsor

Spider Project is most functional and powerful professional project management software.

Top Posters