?
Solved

Access to Project finish date changes

Posted on 2003-03-26
8
Medium Priority
?
389 Views
Last Modified: 2007-12-19
i have a system here where a project is created from a
template. that project is then sent to a oracle database.
from oracle i pull pieces of the data into Access for
report generation. as one of my report options the user
can send those pieces of data in a read only state back to
project. once the data is back in project many of the
finish dates are not accurate. they are 1-3 days later
than what they show in access. my first thought was the
calandar in project must have different holidays or the
workweek was set different but i have verified that the
calandar is the same as the calandar in the template that
the original project is created.

any other ideas?
0
Comment
Question by:Bangerter
  • 3
  • 3
6 Comments
 
LVL 2

Author Comment

by:Bangerter
ID: 8213750
i should note that i am using Access97 and Project98
0
 
LVL 1

Expert Comment

by:Nephil
ID: 8215000
I believe that project will accomidate for resources in such a way that if your resources are filled it will move out the dates.  Are you start dates changing also?  From my experience, I would think that the problem would be in Project not it Access.  Try overloading your resources with time and see if that changes the dates.  Maybe you can change your template to use "Must Start On" or "Must Finish On" constraints for the tasks.  This is assuming that you are not using a resource pool.  I am not sure if there is a way to have a template automatically hook up to a resource pool.  Also, I am not certain about the Oracle factor, although, I doubt that would be the problem. I have not used Oracle in that way.

Hope this helps.

Nephil.
0
 
LVL 2

Author Comment

by:Bangerter
ID: 8218395
i have verified that the dates are all accurate in access. i thought too that the resources may be pushing the dates so i changed my import map to not pull in any durations. as it turns out the duration is back caluculated once the data is in there. i even tried to force a duration through the map but project just ignored it and recalculated the duration based on the start date and the inaccurate finish date. oracle has nothing to do with it other than its just a holding tank for the data. as far as what i am doing here, any data manipulation gets done in access.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 1

Expert Comment

by:Nephil
ID: 8220872
Did you try setting the tasks to the "Must Finish On" constraint?  I might be able to get a better idea if you can post some code.
0
 
LVL 2

Author Comment

by:Bangerter
ID: 8221143
i dont have control of the project template that the projects originate in. the company here bought a package software with all that. i just have control over once the data gets into access. so i cant set the contraint youre talking about. here is the code that i have in my own project template that retrieves the data from access:

Private Sub Project_Open(ByVal pj As MSProject.Project)

            MapEdit Name:="ClinopAccessImport", Create:=True, OverwriteExisting:=True, _
                DataCategory:=0, CategoryEnabled:=True, TableName:="tGantt", _
                FieldName:="unique ID", ExternalFieldName:="ID"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Name", ExternalFieldName:="name"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="actual start", ExternalFieldName:="actual_start"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="actual finish", ExternalFieldName:="actual_finish"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Start", ExternalFieldName:="Start_Date"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Finish", ExternalFieldName:="Finish_Date"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="notes", ExternalFieldName:="notes"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="outline level", ExternalFieldName:="outline_level"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="outline number", ExternalFieldName:="outline_number"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Text4", ExternalFieldName:="Text4"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Text5", ExternalFieldName:="Text5"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Text6", ExternalFieldName:="Text6"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Text7", ExternalFieldName:="Text7"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Text8", ExternalFieldName:="Text8"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="number11", ExternalFieldName:="number11"
            MapEdit Name:="ClinopAccessImport", DataCategory:=0, _
                FieldName:="Duration", ExternalFieldName:="Duration_display"
    DisplayAlerts = False
    FileOpen Name:="c:\ClinOpRpt\UserRpt_Dev.mdb", ReadOnly:=True, Table:="tGantt", map:="ClinopAccessImport"
    ActiveProject.ProjectStart = "1/1/90"
    ActiveProject.Application.TimescaleEdit MajorUnits:=pjTimescaleYears, MinorUnits:=pjTimescaleMonths, MajorLabel:=pjYear_yyyy, MinorLabel:=pjMonth_mmm, majorcount:=1, minorcount:=1, majorticks:=True, minorticks:=True
    Sort Key1:="Finish", Ascending1:=True, Renumber:=False
    GanttBarStyleEdit Item:="1", RightText:="Finish"
    GanttBarStyleEdit Item:="4", RightText:="Finish"
    GanttBarStyleEdit Item:="6", RightText:="Finish"
    SelectTaskColumn Column:="Duration"
    TableEdit Name:="&Entry", TaskTable:=True, NewName:="", FieldName:="", NewFieldName:="Text5", Title:="Phase", Width:=10, Align:=1, ShowInMenu:=True, LockFirstColumn:=True, DateFormat:=255, RowHeight:=1, ColumnPosition:=2, AlignTitle:=1
    TableApply Name:="&Entry"
    ColumnBestFit Column:=4
    SelectTaskColumn Column:="Indicators"
    TableEdit Name:="&Entry", TaskTable:=True, NewName:="", FieldName:="", NewFieldName:="Text7", Title:="Clinical Team", Width:=10, Align:=0, ShowInMenu:=True, LockFirstColumn:=True, DateFormat:=255, RowHeight:=1, ColumnPosition:=1, AlignTitle:=1
    TableApply Name:="&Entry"
    ColumnBestFit Column:=3
   
    Sort Key1:="Text7", Key2:="Finish", Renumber:=False
    DisplayAlerts = True
End Sub
0
 
LVL 1

Accepted Solution

by:
Nephil earned 800 total points
ID: 8221496
I don't see anyway that you will be able to solve your problem easily without having control over the template.  The only slight possibility that I can think of is manipulating the constraint programatically from Access by referencing the project library and opening the destination project.  With a litte exploring I see that there is a ConstraintDate and ConstraintType property of the task object.  However, I must admit that this is beyond my experience.  Sorry I couldn't help more.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question