Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cannot access read-only file 'filename'.

Posted on 2006-10-27
8
Medium Priority
?
309 Views
Last Modified: 2010-04-27
I have a directory on our file server with 24 excel files in it.  Out of those files, 6 of them give the following error message when you try to open them:

Cannot access read-only file 'filename'.

Then when you click OK, you get the following message:

Cannot access 'filename'.

I have checked the properties and none of these files are marked as read-only.  I have tried opening the files from both explorer and inside excel.  Any ideas?

These are incredibly important files - its our budget sheets for next year.
0
Comment
Question by:magicspringsadmin
  • 4
  • 2
7 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 17822076
Try copying the files to your local hard disk - can you open them then?

Kevin
0
 

Author Comment

by:magicspringsadmin
ID: 17822153
When I try to copy them to my local disk I get the following:

***********************************
Cannot copy 'filename': Access is denied.

Make sure the disk is not full or write-protected
and that the file is not currently in use
***********************************

I am the administrator on the system, so I have full access.
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 17822171
This is beyond Excel. I'll see if I can get the quesiton move to another TA.

Kevin
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:magicspringsadmin
ID: 17822225
The OS is Microsoft Server 2003.
0
 

Author Comment

by:magicspringsadmin
ID: 17822467
Some additional info:
When I look at the files in explorer, those 10 files don't show anything for "Owner".
0
 
LVL 11

Accepted Solution

by:
jimbecher earned 2000 total points
ID: 17823994
I would set the ownership to "administrator". From the server in windows explorer right click on the files, go to properties, security, advanced and owner. Take ownership. Another possibility is to reboot the server. If someone has that Excel file open and their workstation crashes it can keep other users from accessing it until the server is rebooted.
0
 

Author Comment

by:magicspringsadmin
ID: 17824435
By taking ownership I was able to get it to work.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question