Background
When you attempt to open the Visual Basic Editor in Project 2007 Professional connected to Project Server the system returns the error "Error accessing file. Network connection may have been lost."
Resolution
In this case the VBA stream in the e-global has become corrupted. To fix the problem without recreating the enterprise global, restore the last e-global backup from your Archive database. If you do not have a backup of the e-global file, then you must recreate it using the following procedure:
-
Backup your system
-
Save all of your enterprise views, tables, filters, reports, groups, forms, maps and toolbars and move them to an MPP file.
-
Run the SQL script that creates the e-global (eglobal.sql). The script is located in:
c:\Program Files\Microsoft Office Servers\12.0\Sql\Project Server\CORE\1033 (Your installation drive may vary)
-
Once the e-global is rebuilt, check it out, open the MPP file you used to save all of the elements and then use the organizer to move everything back. Note that in Project 2007, custom fields and calendars are not stored in the e-global as they were in 2003.
This is a known issue with Project Server 2007. To avoid this problem, always save the e-global before closing it.