Interface with MsProject from MsAccess

Rate

Grego Associate Join Date: Aug 2005 Posts: 54	Interface with MsProject from MsAccess 01/19/2009 5:06 PM
	How do I interface with MsProject from MsAccess? I created a MsProject document outlining work schedule of different work activites and thought it would be interesting if I can relate to the specific data values in MsProject (i.e specific work activity, start date, finish date, percentage of work completed, etc) from MsAccess (these data values are automatically copied to Access file.)
	Register to Reply

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

These comments received enough positive votes to make them "good answers".

Daddio926 Commentator Join Date: May 2008 Location: St. Paul , MN Posts: 79 Good Answers: 6	#1 Re: Interface with MsProject from MsAccess 01/21/2009 8:36 AM
	First and easiest might be saving your MPP file as an MDB file. The MDB tables could then be linked into another MDB file that you use to analyze the Project File. The original MDB (saved as) can be opened in project. Just scroll down to the .mdb option in the file type box. A more involved method would be to us MS project object. To share data between the applications you will need to work with the MS Project API (I am assuming you already work in the Access API). A couple of links to the Project Object Model are: http://www.aspose.com/Products/Aspose.Tasks/Api/Aspose.Tasks.MPPFile.html http://hearwhat.blogspot.com/2004_03_01_hearwhat_archive.html#108028565677237750 Good Luck.
	Register to Reply Good Answer (Score 2)

These comments received enough positive votes to make them "good answers".

	Got Something to Say?
	Ask a Question Start a Discussion

	Aerospace
	BioMech & BioMed
	Chemical & Material Science
	Civil Engineering
	Communications & Electronics
	Education and Engineering Careers
	Electrical Engineering
	General Discussion
	Instrumentation
	Manufacturing
	Mechanical Engineering
	New Technologies & Research
	Software & Programming
	Sustainable Engineering
	Transportation

	Site Directories
	Forum Directory Blog Directory User Group Directory RSS Feeds CR4 Rules of Conduct CR4 FAQ Site Glossary Who's Online (78 right now) Show Members