Project - Project Database (MPD files)

Asked By TimPeterso

22-Jun-07 04:59 PM

When a Project Database (MPD) file is edited in Project, is the database
dynamically affected by the changes or does the file have to be saved?
Likewise, if changes are made to the MPD file directly (using Access), can
the data in the Project window be dynamically updated without closing the
Project window and re-opening the MPD file in Project?  It seems to me that
the updating between applications happens only when the data is saved
(Project to Access) or closed and re-opened (Access to Project).
Unfortunately, the changes are not dynamic as with ODBC.  Is this correct?

22-Jun-07 10:11 PM

Correct. There is no dynamic update with any file type.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx


----------------------------------------------------------------------------------------------------

24-Jun-07 06:39 PM

When a file is opened, you are really playing with a locked copy of the file.
The original is not replaced until there is a save action.  So,  if you save
a file to MPD and then play with it in Access, you can also open another copy
in Project and edit that one too.  Last save wins-- it's called a "race
condition"

You could connect to an ODBC source (such as SQL or Oracle) to avoid the
problem depending on the record locking scheme used.

This would apply to any file, not just Project files
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for  FAQs and more information
about Microsoft Project