Updated Microsoft Project to Microsoft Access Converter File

• 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

Danprj2a.exe Danish

Engprj2a.exe English

Frnprj2a.exe French

Gerprj2a.exe German

Itnprj2a.exe Italian

Spnprj2a.exe Spanish

Sweprj2a.exe Swedish

http://www.microsoft.com/downloads/search.asp

Instructions for Installing

1. 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.



2. 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.



3. You may get the message,
   
   Warning! PROJ2ACC.DLL already exists. Overwrite (y/n)?
   
   Type y and click OK.



4. If you want, you can delete the file copied in Step 1.

Additional query words:

Keywords : kbfile kbprg kbdta kb2000
Version : 4.00
Platform : WINDOWS
Issue type : kbhowto