none
Project Proffesional 2007 Macro Error :"Error accessing file. Network connection may have been lost. RRS feed

  • Question

  • Hi

    One of our clients use MOSS 2007 SP2 AUG CU and MOPS 2007SP2 AUG CU with client machines on MSP SP2. In the custom config done for the client we have included a fair amount of macro's. The problem now is that users are getting the "Error accessing file. Network connection may have been lost." error, when trying to run a macro. This only happens with specific projects and no users can run the macro's in those projects. The network connectivity is 100% as all other comms happens as normal. The schedules also saves and publishes as normal. Microsoft suggested we delete the local global file templates on the client PC's, but as expected this did not resolve the issue.

    When trying to delete the macro's from the specific project using the Organiser, it simply does not execute on the delete demand. Trying to delete it from VB for the specific project, we get a Visual Basic error stating "System Error &H80040111 (-2147221231), and if you click OK on the popup message for this error, another popup displays "Out of Memory".

    When trying to replace the macros for the specific project by copying it from the global using the Organiser, the copy fails with an error message referring to a log file which simply states "Line 2: The Form or MDIForm name frmProgressReport is already in use; cannot load this form.". If you then click OK on the Error massage, another message is displayed which states that the form we wanted to load wil not be loaded as the name already exists.

    Trying to edit the maco for the specific project in Visual Basic also gives an error.

    What we have found is that, when opening another project for which we dont experience these problems, and then open the problematic project, we dont get the errors, but if you open the problematic project first, the error occurs again.

    When saving the project as a file on the computer, the same errors occurs during the save.

    Does anyone know how we could resolve this?

    Regards

    Coenraad Swanepoel

    • Moved by Alexander.BurtonModerator Tuesday, July 27, 2010 11:49 AM Moving to the Customisation and Programming forum where the question is more likely to be answered. (From:Project Server General Questions and Answers)
    Tuesday, July 27, 2010 11:42 AM

Answers

  • Hi,
     
    You might want to take a look to a blog post of mine:
    http://msepm.hsquared.be/?p=25
     
    The procedure mentioned in the post is no guarantee for success, but if
    it works, you don't have to recreate your project (or delete and save
    from backup).
     
    I hope this helps,
    Hans
     
    Coenraad Swanepoel wrote:
    >
    > Hi
    >
    > One of our clients use MOSS 2007 SP2 AUG CU and MOPS 2007SP2 AUG CU
    > with client machines on MSP SP2. In the custom config done for the
    > client we have included a fair amount of macro's. The problem now is
    > that users are getting the "Error accessing file. Network connection
    > may have been lost." error, when trying to run a macro. This only
    > happens with specific projects and no users can run the macro's in
    > those projects. The network connectivity is 100% as all other comms
    > happens as normal. The schedules also saves and publishes as normal.
    > Microsoft suggested we delete the local global file templates on the
    > client PC's, but as expected this did not resolve the issue.
    >
    > When trying to delete the macro's from the specific project using the
    > Organiser, it simply does not execute on the delete demand. Trying to
    > delete it from VB for the specific project, we get a Visual Basic
    > error stating "System Error &H80040111 (-2147221231), and if you click
    > OK on the popup message for this error, another popup displays "Out of
    > Memory".
    >
    > When trying to replace the macros for the specific project by copying
    > it from the global using the Organiser, the copy fails with an error
    > message referring to a log file which simply states "Line 2: The Form
    > or MDIForm name frmProgressReport is already in use; cannot load this
    > form.". If you then click OK on the Error massage, another message is
    > displayed which states that the form we wanted to load wil not be
    > loaded as the name already exists.
    >
    > Trying to edit the maco for the specific project in Visual Basic also
    > gives an error.
    >
    > What we have found is that, when opening another project for which we
    > dont experience these problems, and then open the problematic project,
    > we dont get the errors, but if you open the problematic project first,
    > the error occurs again.
    >
    > When saving the project as a file on the computer, the same errors
    > occurs during the save.
    >
    > Does anyone know how we could resolve this?
    >
    > Regards
    >
    > Coenraad Swanepoel
    >
     
    Tuesday, July 27, 2010 2:02 PM
    Moderator

All replies

  • Hi Coenraad,

    I saw this issue several times. You can solve by saving your project locally as XML, and create a new project from XML file and save it back to server.

    Be aware of that UIDs of project, tasks and assignments will change. So in my case I didn't delete the project from server before saving the new file, but I used 'overwrite existing file'. In this case at least ProjectUID was kept. But this is only important if you use timesheets, your project has already reported hours in timesheets and you have reports using timesheet and project data or you are using MSP_Project_Timesheet cube.

    Regards
    Barbara

    Tuesday, July 27, 2010 12:09 PM
    Moderator
  • Hi,
     
    You might want to take a look to a blog post of mine:
    http://msepm.hsquared.be/?p=25
     
    The procedure mentioned in the post is no guarantee for success, but if
    it works, you don't have to recreate your project (or delete and save
    from backup).
     
    I hope this helps,
    Hans
     
    Coenraad Swanepoel wrote:
    >
    > Hi
    >
    > One of our clients use MOSS 2007 SP2 AUG CU and MOPS 2007SP2 AUG CU
    > with client machines on MSP SP2. In the custom config done for the
    > client we have included a fair amount of macro's. The problem now is
    > that users are getting the "Error accessing file. Network connection
    > may have been lost." error, when trying to run a macro. This only
    > happens with specific projects and no users can run the macro's in
    > those projects. The network connectivity is 100% as all other comms
    > happens as normal. The schedules also saves and publishes as normal.
    > Microsoft suggested we delete the local global file templates on the
    > client PC's, but as expected this did not resolve the issue.
    >
    > When trying to delete the macro's from the specific project using the
    > Organiser, it simply does not execute on the delete demand. Trying to
    > delete it from VB for the specific project, we get a Visual Basic
    > error stating "System Error &H80040111 (-2147221231), and if you click
    > OK on the popup message for this error, another popup displays "Out of
    > Memory".
    >
    > When trying to replace the macros for the specific project by copying
    > it from the global using the Organiser, the copy fails with an error
    > message referring to a log file which simply states "Line 2: The Form
    > or MDIForm name frmProgressReport is already in use; cannot load this
    > form.". If you then click OK on the Error massage, another message is
    > displayed which states that the form we wanted to load wil not be
    > loaded as the name already exists.
    >
    > Trying to edit the maco for the specific project in Visual Basic also
    > gives an error.
    >
    > What we have found is that, when opening another project for which we
    > dont experience these problems, and then open the problematic project,
    > we dont get the errors, but if you open the problematic project first,
    > the error occurs again.
    >
    > When saving the project as a file on the computer, the same errors
    > occurs during the save.
    >
    > Does anyone know how we could resolve this?
    >
    > Regards
    >
    > Coenraad Swanepoel
    >
     
    Tuesday, July 27, 2010 2:02 PM
    Moderator
  • Thanks Hans

    Solution 1 from your post solved the issue.

    Kind Regards
    Coenraad Swanepoel

    Wednesday, July 28, 2010 7:38 AM