Project Server 2007 VBA: 访问文件错误，网络连接可能已丢失

在Project Professional 2007 中签出企业全局设置, Alt+F11打开VBA编辑器时，弹出N次"访问文件错误，网络连接可能已丢失"提示，之后企业全局设置的VBAProject就消失了，也就是说没有办法对企业全局进行VBA编码。

 

在网上找到了答案, 原文如下：

http://projectserverblogs.com/?p=2228

 

 

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

 

 

也就是登录 PWA，在服务器设置-数据库管理-管理性还原, 选择企业全局设置 - 还原

 

出现问题的原因，有可能是代码中的编码，我是直接Copy过来，部份注释变成了乱码。

也有可能是VBA代码没有进行编译，

我删除乱码，导入证书后重新编译代码，再签入，一切恢复正常。