Inserting a subproject via VBA (MS-Access/MSP)

[Mladen Wraz]

I am creating a small Access-Application which handles projects and strings
them together into a Master-project as "inserted projects" using Access 2000
and MSP 2000. Acces ist the leading VBA-host and has to be. Everything works
out fine for the first inserted project (subproject is linked). With the next
inserted projects, the hierarchy breaks down an nothing works at all - no way
to open the crippled "subprojects).

If I compare the contents of the relevant Access-Tables for manually and
automatically generated subprojects there seems to be no difference.

I took all my information from "Microsoft Project 2002 Database Information"
and since everything looks alike in MSP 2000 I thought this must actually
work.

Can anybody help. I am desperate. Thanks.

 

[Rod Gill]

If you are using automation, then record a macro of what you want.

If you are creating an Access database project for MS Project to open then
follow the prjdb.htm very carefully. The flags you set are absolutely
critical. Project corruption occurs sometimes even if one flag is wrong.
Otherwise, you updates are ignored.