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?
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.

SirjacksinurboxCommented:
Have you tried only giving modify permission?
0
oBdACommented:
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

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
SirjacksinurboxCommented:
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
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 Legacy OS

From novice to tech pro — start learning today.