Microsoft KB Archive/125305

{|
 * width="100%"|

PRJ4: OpenFromDatabase Causes Error When Used to Open File

 * }

Q125305

-

The information in this article applies to:


 * 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

-or-

Project finish date not valid

-or-

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 PRJ4: 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/technet/year2k/product/product.asp" Additional query words: Open From Database y2k

Keywords : kbcode kberrmsg kbprg kbdta kb2000 kbofficeprog

Issue type : kbbug

Technology :