Knowledge Base

Negative Numbers Converted to Positive with Save To Database

Article ID: 148360

Article Last Modified on 8/30/2002

Microsoft Project 4.1 Standard Edition

This article was previously published under Q148360

SYMPTOMS

In Microsoft Project, when you use the Save To Database command to save a project to a Microsoft Access database, costs or amounts in the number fields that are negative in the project are converted to positive numbers in the database.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Project listed above.

This problem was corrected in Microsoft Project for Windows 95 version 4.1a.

MORE INFORMATION

When you save a project to a Microsoft Access database using the Save to Database command, the following fields are converted to positive numbers:

Task Fields

Fixed Cost
Actual Cost
Baseline Cost
Remaining Cost
Cost
Cost1
Cost2
Cost3
Number1
Number2
Number3
Number4
Number5

Resource Fields

Actual Cost
Baseline Cost
Cost
Cost Per Use
Remaining Cost

NOTE: The Cost Variance, BCWS and BCWP fields do not display this behavior.

Keywords: kbinterop kbprb kbusage KB148360