NTFS permission Win2k8 Srv

Hello ,

I would like to have a folder permission to not to create any file or folder but to update existing Excel files.

I have tried everything with special permission but in vain ,it's not allowing users to update the file.

Thanks
leolink1982Asked:
Who is Participating?
 
oBdAConnect With a Mentor Commented:
Not possible, sorry. When Excel saves, it first writes to a temporary file in the document folder, then the original file is deleted and finally the temporary file renamed to the original name. In other words: if a user can not create files in a folder, he can't save/update Excel documents in that folder.
Description of the way that Excel saves files
http://support.microsoft.com/kb/814068
0
 
SirjacksinurboxCommented:
Have you tried only giving modify permission?
0
 
SirjacksinurboxConnect With a Mentor Commented:
Then there really isn't a way to do what you're looking for. Excel will always create that temporary file and unless you grant read/write/modify the users, they won't be able to do anything.

Either grant the users read/write/modify to that folder, or find somewhere else to put those files.

You could also set up versioning for that folder and allow a check out/check in process. That would ensure that it only modifies the file without allowing the user to do otherwise with it.
0
 
arnoldCommented:
Excel and any office file requires create and delete writes dealing with lock file ~filename that s created to make sure no two users open the same file for modifications.
Depending on what you want to alive, auditing might be what remains, you could use a document management system where users can checkout the file, edit it locally and then upload it back.
0
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.

All Courses

From novice to tech pro — start learning today.