MS Access v. MS Project...

  • Thread starter Thread starter PB
  • Start date Start date
P

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??)...
 
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
 
PB said:
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??)...
Click to expand...

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
 
Back
Top