Seeking MS-Project 2003 Access MDB Dictionary/Relationships/Querie

[Kevin Manhal]

Am lookiing to not reinvent the wheel.

I'm looking for:
1. the Access MDB data dictionary.
2. A completed ERD which would be found in Tools/Relationships.
3. Pre-Built Queries to tap the data.

Thanks for help on any, or all of the above.

 

[JulieS]

Hi Kevin,

The database information for Project can be found in the PJDB.HTM (Project
2003) file stored on your computer.

See also:
http://www.microsoft.com/downloads/...c2-3ac1-4fc8-8e67-d908cdb9faf2&DisplayLang=en

for the Project 2003 DB Schema.

Sorry, off the top of my head, I don't know if there is a library of Queries
available.
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information about
Microsoft Project

 

[Jack Dahlgren]

Kevin,

Julie answered your question about where to find the data, but I should
point out that in the access database there are no defined relationships.
Those are handled by the business logic in the application rather than
through relationships in the database. This means if you want to update tasks
within access, you can not rely on any sort of referential integrity to do so.

-Jack Dahlgren

 

[Kevin Manhal]

Julie,

1). Thanks forthe help on locating the schema. I used the URL you provided.
PJDB.HTM wasnot on my computer.

2). Would you know if anyone has placed this schema into the Access DB
Tools/Relationships?



found it in the URL

 

[JulieS]

Hi Kevin,

You're welcome for the assistance.

I would search again for the PJDB.HTM file. It is usually installed in
in the 1033 folder (English Install) in the program directory where
Project is installed. (Note the file is for Project 2003 if you are
using Project 2002, I think the file is PRJDB.HTM).

As Jack noted, a Project file saved as an Access DB file will not show
relationships in the Relationships window in Access. The relationships
are handled by Project rather than through database relationships. That
is why finding the PJDB.HTM file is key.

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[JackD]

Kevin,

The relationships are a bit funny. I think that there are some where you
don't want a "hard" relationship.
In otherwords, sometimes you want the relationship to cascade one way and
other times you want it to go the other way.
On top of this, there are other tricks going on in the database such as
storing past values in binary blobs in case an update fails or things like
that happen. There are also flags that need to be set in the database for it
to accept updates in the database. These have a sort of "relationship" but
not really.

Because of this, entering those relationships in access will break project.

Look for projdb.htm and see if you can find the information you are looking
for.

-Jack Dahlgren

 

[Kevin Manhal]

Thanks Julie.

Thanks again. I now have what I need (for the moment). Found in C:\Program
Files\Microsoft Office\OFFICE11\1033.

 

[JulieS]

You're welcome Kevin and thanks for the feedback.

Julie