Create a new task in MS Access

[Stephen]

I am trying to create a new task for a MS project using MS Project 2002
standard from within MS Access. I have saved a sample project as an mdb and
then added a new record (task) to the MSP_TASKS table. For example, I start
with 8 tasks and want to add a 9th task from with Access and then open the
mdb with MS project and see the added task. Each task has a UID (1-8
initially) and I increment the UID to 9 for my added task. When I open the
mdb in Project in the task view I cannot see the 9th task. When I attempt to
then add another task (using the insert task menu) the project adds a task
with 10 as its ID. Thus, I have added task 9 somewhere within my project (at
least partially). Furthermore, after I open my mdb with the added
record/task in project and then export the project again(or "save as" an mdb
under a different name), my task 9 is in the Access MSP_TASKS table. This
leads me to believe there is a step or two I have failed to do in order to
get the added task (via Access) to be visible in the Task Gannt chart and
Task list.

Any help would be appreciated.

Thanks

Stephen

 

[Stephen]

I just learned about the PROJ_EXT_EDITED field in the MSP_PROJECTS Table from
the export, it seems to have solved my problem, but I think my clarifying
question is what do the following fields do:
PROJ_EXT_EDITED_NUM,
PROJ_EXT_EDITED_CODE,
PROJ_EXT_EDITED_FLAG,
PROJ_EXT_EDITED_TEXT

I am assuming they are there for a reason and may impact the overall success
of what I am trying to do.

Again thanks for any help,

Stephen

 

[Rod Gill]

Read and thoroughly digest the prjdb.htm file stored in one of Project's
program folders. It's also on the Project CD.