File permissions question for windows server sbs 2011 standard, but it's just general windows question

there's group A and group B.  group A can access the share \\server\folder1

The share permissions on folder1 is everyone has full control
the ntfs permissions give group A the folder, subfolder and files full access.

we want group b to have full access to 1 file (an excel spreadsheet) in folder 1
We gave group b full access to that file.  But since they have no permissions to folder 1 itself, someone here said to give list folder / read data permissions.

but when a group b user tries to save, they get access denied.  we don't want them to open or do anything with any other file in that folder.
BeGentleWithMe-INeedHelpAsked:
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.

Lee W, MVPTechnology and Business Process AdvisorCommented:
It's really unwise to set permissions on a single file different from a folder.  A better solution would be to create a shared drive that allows both groups full access to the folder.

As for permissions, Most Restrictive wins.  If the Share permissions don't list Group B and/or are listed as read only, then it doesn't matter what the NTFS permissions are.  

Further, I generally set Share permissions to EVERYONE - FULL - then I set permissions by NTFS.
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
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
Windows 7

From novice to tech pro — start learning today.

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.