none
File locked on network storage

    Pregunta

  • Hi, we've have at least 4 computers using the same username in our enviroment (pro and cons about that can be left out). And sometimes files on our network storage gets locked, "Locked by <our username>". But still if we kill all instances of excel on our 4 machines. The files still remain locked.

    And our it-support can only see which user locks the file, and that do we already know. 

    Is there any way to see which machine/ip that use the file atm?

    We use win xp on the workstations and windows server 2003 at ADs.

    //Elmeholt

    miércoles, 27 de junio de 2012 9:42

Respuestas

Todas las respuestas

  • Hi,

    You can use netstat command, it will show you the active connections on your file server


    Thanks and Regards, Mukesh. This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Please VOTE as HELPFUL if the post helps you and remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    miércoles, 27 de junio de 2012 10:09
  • I dont think this is a good solution, we are more than 500 employees. Is there any other way?

    miércoles, 27 de junio de 2012 10:11
  • You can try this

    http://technet.microsoft.com/en-us/library/bb490961


    Thanks and Regards, Mukesh. This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Please VOTE as HELPFUL if the post helps you and remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    miércoles, 27 de junio de 2012 10:20
  • Well, using the same username and password is one of the cons in this case.  As you already know, tracing file-lock issues with the same credential is difficult.

    This is not really a fix, but something to investigate to help alleviate your problem.  I assume (from your post) that you are using Excel as a flat-file database.

    One, you could enable workbook sharing that will allow multiple users to access and modify the same file without having the file-lock issue.

    Two, you could port your Excel worksheet to an Access database with a data backend and a data entry front end.  Again, that would alleviate  your file lock issue.

    miércoles, 27 de junio de 2012 15:23
  • Hi Elmeholt,

    Thank you for the post.

    Please use Shared Folders Microsoft Management Console (MMC) snap-in to close an open file.
    http://technet.microsoft.com/en-us/library/cc732037.aspx

    If there are more inquiries on this issue, please feel free to let us know.
     
    Regards


    Rick Tan

    TechNet Community Support

    jueves, 28 de junio de 2012 3:24