?
Solved

Share folder: How to prevent multiple users modify the same file?

Posted on 2010-09-08
8
Medium Priority
?
877 Views
Last Modified: 2012-06-27
I have a share folder on 2003 server and several users have write permission. But uer can modify the file even other user already opened it and making modification. How can I prevent this? or is there a better way to workaround?
0
Comment
Question by:okamon
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 7

Expert Comment

by:jesaja
ID: 33630971
what file type is it and what application they are using to edit it
0
 
LVL 9

Expert Comment

by:ken2421
ID: 33630993
On a shared file the last user to save will be the final version. You need sharepont to control this problem and regulate the users who are accessing a file at any given time. It is expensive but it is the way to do what you want.
0
 

Author Comment

by:okamon
ID: 33631839
it's a xsl file. So you are saying the only was is to use sharepoint? no other alternative way?
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 9

Expert Comment

by:ken2421
ID: 33633280
Sharepoint won't allow sharing of an xsl. It will allow you to convert xsl into html. I am not sure what you are hoping to do but generally speaking a file cannot be edited by more than one person at a time without some service managing those changes. They can use a file then exit and then another can use it and exit and so on.

Here is a link to microsoft on sharepoint http://office.microsoft.com/en-us/sharepoint-server-help/convert-an-xml-file-to-a-web-page-HA010215482.aspx

Perhaps this will help you target you goal more specifically.

Good luck,
Holler if you need help.

Ken
0
 
LVL 39

Expert Comment

by:Krzysztof Pytko
ID: 33633851
I'm not sure but this problem is not NTFS permission. NTFS by default disallow using file by more that one person in "modify mode". I would check in that Excel sheet in "Tools -> Share workbook/sheet" if there is checked a box "Allow apply changes concurrently by multiple users" (it's my translation :) but there is only one check box) If it is enabled, just disable it, then users will have a message that "This document is read-only because someone (and they see user login) uses it".

Hope it helps
0
 
LVL 7

Expert Comment

by:jesaja
ID: 33638559
OK, as it is an Excel file office it will by default prevent sharing documents, so it must be set manually.

In Excel 2003 you can disable it as isiek posted

In Excel 2007/10 you go to Review and klick on share workbook it should not be marked
0
 

Author Comment

by:okamon
ID: 33643279
so it means I have to configure it on each user's excel?? there is no way I can configure on the server, example group policy..... ?
0
 
LVL 7

Accepted Solution

by:
jesaja earned 1200 total points
ID: 33647659
So it's happen to all excel sheets?

Even if you create a new file, right?

If so some Standard must have been set, normally I would set this with GPO. I never used it to set this option, so don't know if it's available though.
Check the applied GPO settings on the client (rsop.msc) or with GPO Manager on the server what is applied to the client.

You can use Microsoft's GPO templates for example Office 2010.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=64b837b6-0aa0-4c07-bc34-bec3990a7956&displaylang=en
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Native ability to set a user account password via AD GPO was removed because the passwords can be easily decrypted by any authenticated user in the domain. Microsoft recommends LAPS as a replacement and I have written an article that does something …
The Windows Firewall provides an important layer of protection and a rich interface to configure it. Unfortunately, it lacks item level filtering. This article details my process of implementing firewall-as-code to reduce GPO bloat.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question