?
Solved

Access to Project finish date changes

Posted on 2003-03-26
8
Medium Priority
?
385 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

764 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