The information in this article applies to:
- Microsoft Project for Windows, version 4.0
SUMMARY
The Microsoft Project "Save to Database" utility allows you to save and
open project information to and from a Microsoft Access database. One
component of this utility is the Proj2acc.dll file.
An updated Microsoft Project 4.0 to Microsoft Access database converter
(Proj2acc.dll) file is available in seven languages. The files are
available from the Microsoft Software Library. For information about
downloading these files, please see the "Instructions for Downloading"
section later in this article.
The database converter generates a Microsoft Access 2.0-format database,
which can also be used in later versions of Microsoft Access.
MORE INFORMATION
The new Proj2acc.dll file corrects the following issues:
- Any dates in the year 2000 are incorrect. For example, "4/15/2000" is
changed to "4/15/100" instead of "4/15/00". When opening from the
database, an error is generated that states that the date is invalid;
the date is ignored.
- Non-working day calendar changes may be incorrect. For example, if you
use the D/M/Y date order and set 8/1/97 (August 1, 1997) as a non-
working day, when opened from the database, January 8, 1997 is instead
shown as a non-working day.
- Percent complete values between one and nine percent are incorrect. For
example, if you enter 3% on a task, when you save and open from the
database, the value is 30%.
- Erroneous dates may be produced if dates are at the beginning of the
month. For example, if your project start date is set to 1/6/97 (again,
assuming D/M/Y ordering), and you save to database, when opening the
file, you may receive an error indicating invalid dates and the date is
ignored. This error occurs in the French and German versions.
- Setting the currency format to "0,00 $/h" causes the loss of resource
rate information when opening from the database. For example, if you
enter 5,50 $/h in the overtime rate of a resource and you save to the
database, when you open from the database, you get a message indicating
that the rate is invalid and your rate appears as 0,00 $/h.
- The currency symbol placement setting is not respected after saving and
opening from and to the database. For example, if you place the currency
symbol such that your rates appear as "0.00 $/h" and you save to the
database, when opened from the database your rates appear as "$0.00 /h".
Instructions for Downloading
The following files for your language version of Microsoft Project are
available for download from the Microsoft Software Library:
~ Danprj2a.exe (size: 97860 bytes)
Danish
~ Engprj2a.exe (size: 97622 bytes)
English
~ Frnprj2a.exe (size: 98445 bytes)
French
~ Gerprj2a.exe (size: 98447 bytes)
German
~ Itnprj2a.exe (size: 98164 bytes)
Italian
~ Spnprj2a.exe (size: 98375 bytes)
Spanish
~ Sweprj2a.exe (size: 98090 bytes)
Swedish
For more information about downloading files from the Microsoft Software
Library, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q119591
TITLE : How to Obtain Microsoft Support Files from Online Services
Instructions for Installing
After you obtain the file that matches your language version of Microsoft
Project, do the following:
- Copy the file to your Windows System directory or folder.
For example, if you have the English version of Microsoft Project,
copy the file Engprj2a.exe to your Windows System directory.
NOTE: You cannot mix languages. For example, if you have the English
version of Microsoft Project, you cannot use the Spanish version of
the Save to Database file contained in Spnprj2a.exe.
- Run the file you copied in step number 1. For example, in the Windows
File manager, change to your Windows System directory, click the file
name and, on the File menu, click run. Click OK.
- You may get the message,
Warning! PROJ2ACC.DLL already exists. Overwrite (y/n)?
Type "y" (without quotation marks) and click OK.
- If you wish, you can delete the file copied in Step 1.
|