MS Project and MS Access

J

JF Bouthillier

Hi all,

Does someone know a good book or webpage that talks about
the interaction of MS Project and MS Access.

I know VBA and I am a fairly advanced programmer.

Thanks.
JF
 
J

JackD

I know of nothing which talks about Project and Access in terms of VBA.
What is it you need to know?
If you are talking about the project database (which can be an access
database) then the best source of information is the document called
projdb.htm which can be found on the project cd or on a computer with
Project installed.
 
J

JF Bouthillier

What I wanted to know was more if there is documentation
on the MS Project API that could be used from MS Access.
For example, is there a way to send some information
coming from access to populate a project schedule in MS
Project?

Thank you for your help.
JF
 
J

JackD

Sure. You just need to read the Project VBA help.
I have examples of working with Excel and Project on my website. Working
with Access and project would be very similar.
Note that creating tasks and dependencies in Project requires a decent
working knowledge of how project works so you will have to study up on that.

You can find the project vba help from within the project VBE
You may need to do a custom install for it to show up as I don't think it is
part of the "Typical" install.

There is also documentation on Project VBA in general here:

http://download.microsoft.com/download/project98/info2/1/WIN98/EN-US/prj98vbe.exe
 
R

ridgewayjc

Jack,
I am trying to modify fields in a Project2000 file from Access2002.
I have read the projdb.htm file and I am "fairly" sure that I have done
what it requires in order to update the Project file BUT
To start off I am only trying to modify the %Completed field for a task
(just to get my feet wet).
The PROJ_EXT_EDITED gets updated to True, the EXT_EDIT_REF_DATA field
gets updated correctly and then the %Completed field "appears" to get
updated correctly - it even "appears" to be correct after I close
Access and open the file with Project, BUT if I close Project and elect
to "save changes" I lose ALL of my data, except for the MSP_PROJECTS
data.

Any ideas?
Thanks
 
J

JackD

%complete is often calculated by project. Try updating actual work and
remaining work, or if there are no resources actual duration and remaining
duration.
 
K

kvidy

Any luck on what you've been trying. I'm also trying to do a very similar
thing and I want to know if you successfully got through. When I tried a
small example with updating actual work and remaining work, Project leaves
the other related/calculated fields uncalculated. As a result the project
database fields has corresponding fields that are incorrect. Like for
instance the % complete or the duration fields remain unchanged and the
tracking details look very irrelevant. Please help if you know. Or is it that
project expects you to update all the related fields as well before importing
it back into Project from access.
 
Top