PRJ4: OpenFromDatabase Causes Error When Used to Open File

• Microsoft Project for Windows, version 4.0

SYMPTOMS

In Microsoft Project, if you open a file using the Visual Basic for Applications OpenFromDatabase command, any of the following error messages may appear:

Constraint Date not Valid

Project finish date not valid

Date not Valid

CAUSE

This problem occurs because the SaveToDatabase routine does not correctly save the year 2000 to the Microsoft Access database.

WORKAROUND

To work around this problem, find the tasks that have Constraint Dates in the year 2000 and create relationships with other tasks so that the constraint is no longer needed. For example, you could create a milestone task at the end of the year 1999 and link the constrained tasks to this milestone with an appropriate lag value. This eliminates the need for a constraint on the task in the year 2000.

NOTE: This workaround works only for schedule dates such as Start and Finish. If there are other dates such Baseline Start, Baseline Finish, Actual Start, Actual Finish, and so forth that are scheduled in the year 2000, then the same error occurs.

STATUS

An updated Microsoft Project 4.0 to Microsoft Access database converter (Proj2acc.dll) file is available for download.

For more information please see the following article in the Microsoft Knowledge Base:

Q160677 Updated MS Project to MS Access Converter File

MORE INFORMATION

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/y2k/

Additional query words: Open From Database y2k

Keywords          : kbcode kberrmsg kbprg kbdta kb2000 
Version           : WINDOWS:4.0
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: March 19, 1999