MS Project saved as a MS Access file

[glenn]

Hello,

I open MS Project and put in a few tasks all of which receive a duration of
one day and then I save the file as an Access Database file. I then exit MS
Project.

Next I open MS Access and open the Access database file I just created in MS
Project. In the MSP_TASKS table, I look for the TASK_DUR field which
represents the task duration. The number 4800 is found as the data for each
task which represents one day. I then change the 4800 to 9600 and then I
save the file and exit MS Access.

Next I start MS Project and open the MS Access file I just altered and saved
in MS Access. What I find is rather perplexing. The durations of the tasks
have changed from one day to being two days but the gantt chart still shows
the duration of the bar as only one day. Also, if I hover my mouse over the
gantt bar, I notice the pop-up to indicate the task has a duration of two
days even though its length only indicates it to be one day.

Why am I doing this? Well since you asked, I'll tell you. I am placing an
access database file that represents a MS Project on my web server. Using
Active Server Pages, I am updating the database with new info from a web
browser which is then later displayed to a client machine via the web.

Any thoughts on this "weird behaviour" would be greatly appreciated.

 

[Jan De Messemaeker]

Hi,

In tools, options, calculation, is calculation set to automatic?
HTH

 

[Rod Gill]

Have you read thoroughly the projdb.htm file that describes how to update
the database? There are flags you have to set otherwise project corruptions
often occur. Your project may have corrupted if you didn't set the Ext_ref
flag (or whatever it's called I can't remember off hand).