Error accessing file: Network connection may have been lost when accessing VBA Macros stored in the Enterprise Global in Project Server 2003 and 2007
13 April 2009I see this problem reported in the Microsoft Public Newsgroups regularly, and it is a known issue with both Project Server 2003 and Project Server 2007. When you try to access a macro stored in your Enterprise Global File when using Microsoft Office Project 2007 or Microsoft Office Project 2003 while attached to either Project Server 2003 or 2007, the system reports the “Error accessing file: Network connection may have been lost.” This error often indicates corruption in the VBA stream in the Enterprise Global File. The most common cause of this corruption happens when you close the Enterprise Global File without first saving the file. To avoid this problem, always save your Enterprise Global File before closing it.
The easiest way to recover from this error is to restore an Administrative Backup copy of your Enterprise Global File. Restoring a good copy of the file overwrites the corruption resolving the problem. This is exactly the type of situation that the Administrative Backup feature in Project Server 2007 is most useful. It also presents a very strong argument for scheduling administrative backups to run each night. Likewise, it is a strong argument for backing up the Enterprise Global file in Project Server 2003 on a regular basis, which is a manual process. My best practice recommendation is to backup the Enterprise Global File just before you make any changes to it so you always have the latest version to fall back to.
Please visit the original for the rest of this article.
Originally from Project Server Help Blog: Posts on April 13, 2009, 11:20am
Popularity: 3% [?]
Other posts like this one:
No comments yet