MS Access v. MS Project...

[PB]

Hi!

I have to track projects that have definitive end dates with a number of
tasks.

I presently have the information in a MS Access db and I'd like to be able
to open Project from the Access db to display a Gantt chart that I'd be able
to post on a web page using a query.

Is this do-able? I've found that Project can't hold all the info we need,
but Access can't produce the Gantt charts (or can it??)...

 

[Douglas J. Steele]

Take a look at the Calendar Reports sample Duane Hookom has at
http://www.access.hookom.net/Samples.htm

 

[Ray C]

No, Access does not produce Gantt charts (out of the box).

The following IS do-able though:
You can use VBA code to create an instance of MS Project, create the
project, enter all the pertinent data required by MS Project, save the
project, and then open the project in MS Project to view the Gantt chart.

Ray

 

[Bruno Laurans]

Erhtj(§kèl!çmàliku;,jnhg


Le 28/03/08 20:58, dans (e-mail address removed),

 

[JulieS]

Hi!

I have to track projects that have definitive end dates with a number
of
tasks.

I presently have the information in a MS Access db and I'd like to be
able
to open Project from the Access db to display a Gantt chart that I'd
be able
to post on a web page using a query.

Is this do-able? I've found that Project can't hold all the info we
need,
but Access can't produce the Gantt charts (or can it??)...

If you are using a version of MS Project other than the 2007 version,
you can save project files as an access db. For detailed information on
manipulating the project data through access, see the prjdb.htm file
located at the installation point for Project.

Julie