• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 870
  • Last Modified:

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

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
okamon
Asked:
okamon
  • 3
  • 2
  • 2
  • +1
1 Solution
 
jesajaCommented:
what file type is it and what application they are using to edit it
0
 
ken2421Commented:
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
 
okamonAuthor Commented:
it's a xsl file. So you are saying the only was is to use sharepoint? no other alternative way?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
ken2421Commented:
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
 
Krzysztof PytkoActive Directory EngineerCommented:
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
 
jesajaCommented:
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
 
okamonAuthor Commented:
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
 
jesajaCommented:
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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now