MS Project Database Relationship? 2

[pelagic]

Hi there,

There are 27 tables in MS Project database, but none of these table have primary key and foreign key. How can I find the relationship among these
tables?


Thanks in advance

pelagic

 

[SkipVought]

Deduction?

Cause & Effect?

Skip,

_[red][/red]

 

[PDQBach]

I don't think you don't mean "MS Project Database", you mean an "Access database storing a Microsoft Project file".

On the other hand, if you really did mean Microsoft Project Database then here's a starting point:

http://www.microsoft.com/downloads/...C2-3AC1-4FC8-8E67-D908CDB9FAF2&displaylang=en

The information you want is far, far beyond anything this forum can provide. Your starting point to gather this information is with the MS Project team itself. Since much of the information in Project is stored in BLOBs (look at all the memo fields in an Access database of a Microsoft project), you'll probably need to sign an NDA to get all the information you need. As a starting point Google "evildoctorporkchop" to find Treb Gatte's blog. He can point you to the right internal contact.

 

[pelagic]

Hi PDQBach,

Thank you very much for your help.

I did mean Microsoft Project database. This is what I did.
1. Save MSProject file using the Save As feature.
2. Save as filename.mpd (Project database)
3. Open filename.mpd in MSAccess.
4. Microsft did not set MSProject relationship at database level. They probably set at application level.

The link that you provided is exactly what I was looking for.

http://www.microsoft.com/downloads/...C2-3AC1-4FC8-8E67-D908CDB9FAF2&displaylang=en

Thanks