PRJ4: Updated Microsoft Project to Microsoft Access Converter File |
Q160677
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 Download Center. 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 Download Center:
Danprj2a.exe Danish
Engprj2a.exe English
Frnprj2a.exe French
Gerprj2a.exe German
Itnprj2a.exe Italian
Spnprj2a.exe Spanish
Sweprj2a.exe Swedish
For additional information about how to download Microsoft Support
files, click the article number below
to view the article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from
Online Services
Microsoft used the most current virus detection software available
on the date of posting to scan this file for viruses. Once posted,
the file is housed on secure servers that prevent any unauthorized
changes to the file.
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 and click OK.
- If you want, you can delete the file copied in Step 1.
Additional query words:
danprj2a engprj2a frnprj2a gerprj2a itnprj2a spnprj2a sweprj2a exe