Custom Report Using Access

[Jim Stoaks]

I have exported the Project data to an Access database and started building
the query I want. However, I want to be able to tie custom fields to the
task data and I can't figure out how the relationship is setup between the
two tables. Can anyone enlighten me? Is there a Project 2003 database
schema out there somewhere showing the relationship between the various
tables?

Thanks

 

[Ed Morrison]

Custom field information is stored in msp_text_fields, msp_number_fields,
etc.

Try the Project Server 2003 Resource Kit
(http://www.microsoft.com/downloads/...51-4f7c-4aa5-9243-a529b8b49015&DisplayLang=en).
The kit contains a database schema for Project Server, but I believe the
ProjERD file is similar to Access.

If you have access to the Project Server 2003 installation disk, look for
\SERVER\DOCS\PJDB.HTM. Again, I believe that this Project Server tables
description is similar to Access.