Using Project from Access

[Randy Galliano]

Hello,

We have the need to take a project file, save it as an .MDB, and add some
tasks to it. I can convert the project to .MDB format, and I see all the
tables. When I manually add a task to the MSP_Tasks table, it never shows
up when I read it back using Microsoft Project. Are there examples on how
to manipulate these tables?

Regards,

Randy.

 

[Brian K - Project MVP]

Hello,

We have the need to take a project file, save it as an .MDB, and add
some tasks to it. I can convert the project to .MDB format, and I
see all the tables. When I manually add a task to the MSP_Tasks
table, it never shows up when I read it back using Microsoft Project.
Are there examples on how to manipulate these tables?

Regards,

Randy.

There is a file that installs with Project called something like
ProjDB.htm that contains instructions on how to do this.

Basically there is a field in the tasks table that is something like
EXT_EDIT that needs to be set to -1 to tell project that there has been
edits made by an application other than Project. If this is set to 0
(default) then Project opens the project from the db but from a Binary
blob field that basically contains the mpp file. It does this for
performance reasons because opening from the tables is slower. Editing
this field to -1 will tell Project to open the project from the tables.

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com