File Permissions

pts.
Tags:
Hardware
Servers
I tried to change the access permissions on a folder on the server to limit the munber of people able to access the spreadsheets in it. This for some reason changed the whole folder to read-only. I have tried to fix this but the read-only box is always checked in the folder properties. However, i am able to access one of the Excel spreadsheets with no problems but the other one gives me the message: "Excel cannot access name.xls. The document may be read-only or encrypted." The file is not read-only when I go into the properties. How can I fix this so I can get into the spreadsheets?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Mcandrcp,

Did you change the permissions to the folder or to individual files ? Is the folder inheriting any permissions from a higher level folder, you should be able to see those by looking at the folder properties and seeing some “greyed” out ticks against particular permission attributes. Can you list out the groups granted permissions on that folder ?

Cheers

Mike

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Amisenin
    Try something simple .. if it works keep it that way: Create a new folder and set the groups you want to give access to. Copy the files there and see the results. That should give you an idea what is happening. Ami
    0 pointsBadges:
    report
  • Worker1
    I've seen scenarios in the past where read only attribute gets locked and files will open in read only mode.I'm assuming you tried a reboot?
    0 pointsBadges:
    report
  • Mcandrcp
    I had changed the permissions to the folder but changed them back instantly when I realised that people couldn't access the documents. All Excel docs in the folder work again now except for the one in question which brings up the error message and won't let me in. I have played around with the permissions but to no avail. When i view the properties for the doc, its not read-only but under the security tab, there are no groups or users and it won't let me add any. Nor will it let me inherit permissions from parent under the advanced button. Can you help me? How can i give users permissions? Thanks
    0 pointsBadges:
    report
  • Lanspeed
    If you're an admin which I guess you must be then you should be able to take ownership of the file in question and then add/inherit the relevant permissions.
    0 pointsBadges:
    report
  • Poppaman2
    Or the file may be corrupt. Try creating a new workbook/worksheet in the same location (call it "test" or some such) and copying and pasting the data to the new file. Are the permission settings now available? If so, you've addressed the issue. If not, again, have you rebooted? A user or process on the network somewhere may have accessed the file and not released control, effectively locking the file. A reboot should cure this...
    0 pointsBadges:
    report
  • Socrates51
    Copy the spreadsheet to a location on your desktop. Delete the spreadsheet from the original folder. Now copy the spreadsheet back to the original folder. You should be able to access the spreadsheet. When you copy a file the permissions default to the original file permissions before the change giving you full access to the copied file.
    0 pointsBadges:
    report
  • Wdorciak
    You may be unable to remove the Read-Only attribute from a folder using Windows Explorer. In addition, some programs may display error messages when you try to save files to the folder. This behavior is by design according to MS KB Q256614. http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q256614
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following