Prevent Deletion of file but allow to modify

We have a situation that our management wants users to be able to open an Excel file and edit the contents and save but not allow them to accidentally or on purpose delete or move the file. Is there some method in Windows to configure a file share like this?
LVL 2
gregurlAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BiniekCommented:
You have to change permission on NTFS volume, where files are stored.

This can be done by modifying the advanced security permissions of the folder/file and make sure that the users do not have permissions  "Delete"  for files and "Delete Subfolders and Files" and "Delete" for folders, so You have to set DENY on these permissions.

And there is useful informations http://www.windowsecurity.com/articles-tutorials/authentication_and_encryption/Understanding-Windows-NTFS-Permissions.html
0
oBdACommented:
Not possible, at least not with Office documents. Excel saves a file by first writing a new(!) temporary file, and if that was successful, it will delete the original and rename the temporary file to the original file name.
In other words: in order for a user to be able to save an Excel document, he'll have to have permissions to delete it as well.
Description of the way that Excel saves files
http://support.microsoft.com/kb/814068
That aside: even if it were possible, it would still not prevent any accidental or deliberate deletion of data contained in the document. If you can edit the contents, you can edit them to contain nothing, and then save an empty file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Explain shadow copies to management and move on.
0
w_richardCommented:
There are specific files and folder monitoring software that would be able to let you know what changes have been made at the files and folder with in the software.

As the requirement you are asking about there is a very less chances as because these changes are a part from the NTFS setting. You can go for a file server monitoring tool and by that you can identify who so ever accessed you excel file or any other files with in you r server.

Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.