MS Project 2003 and Access Databse updateing

[Tim]

I have MS Project saving to an Access databse. We have team members updateing
an access time sheet created in house. We are trying to update the Duration,
Actual Worked, Remaining Duration and Percent in access. I am updateing the
Task table and changing the flags in the project table but it is still not
working. I tried updateing the Task table flag field but it still did not
work. Any help would be appriciated. Thanks

 

[Rod Gill]

prjdb.htm has all the answers. You may be trying to update conflicting data.
Try to begin with just updating Actual Start, Actual Duration and Remaining
Duration. If that works, then try Actual Start, Actual Work and remaining
work. I either case, let Project calculate the % complete itself.

 

[Tim]

Thanks for the update. I am trying to update just the Duration field (In just
the Task Table, TASK_DUR) I do not need to modify the start. Do I need to
update any other fields in that table or any other table ?

Thanks for your help