Reading Project-file in Access

[Robert]

Hi there,

I saves my MS Project 2000-sheet as a database and kan view the tables
in MS Access.

I want to show some details in a form, so how calculates Project the
hours for a given week. I already can view the total amount of hours,
but want this data for a given week.

Is this possible or should I try another method?

Thanks in advance,

Robert

 

[Rod Gill]

Hi,

You can get it, (see projdb.htm in one of Project's program folders), but
for complete accuracy you need to reference the calendar table and do all
sorts of calcs. I find for simple stuff it's quicker and more accurate to
use automation and the timescaledata method.

In Project 2002 onwards you can use the OLEDB driver (PRJOLEDB.htm) to read
time scaled data, but the daily values are inaccurate (fixed in 2003).

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[JackD]

Read the document called projdb.htm that is on your project CD or the
machine where you installed project.
Look particularly at how timescaled data is stored.
I think that it is easier to handle through OLEDB, but you can get the data
from the database IF you have checked the option to store timescaled data in
the database. (tools menu / options/ Save tab I think)

-Jack