Solved

"Cannot Be Accessed" error

Posted on 1998-04-20
8
390 Views
Last Modified: 2012-05-04
I'm getting the following error message:

'00TimeCard.xls' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

I can access the other excel files that reside on the same drive that 00TimeCard.xls is on. So, the server is responding and the location is NOT readonly.

Anyone have any ideas on how I can access this file? Is there a bit I need to clear or something?
0
Comment
Question by:Cyprus
8 Comments
 
LVL 7

Expert Comment

by:spiridonov
ID: 1602669
Open Explorer, click with a right mouse button on the file, select Properties option, check if read-only attribute is set.
0
 
LVL 3

Expert Comment

by:jlove1
ID: 1602670
try to copy the file locally..
then try to open it up. The file may really be READ ONLY. This is fixable by typing
attrib 00timecard.xls -r -a -s -h
in the dos prompt.

Otherwise, the file might be corrupted
0
 

Author Comment

by:Cyprus
ID: 1602671
I guess the file is corrupted...'cause I've done both suggestions and still get the error message. I wonder if it has a virus?
0
 
LVL 3

Expert Comment

by:frazer
ID: 1602672
Have you tried opening the file at another location and/or with a different version of excel?

Hope this helps

Frazer
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Cyprus
ID: 1602673
I think the directory is on a bad sector or something...'cause I just saved and closed a file and then reopened it and now that other file is getting that error message as well. It was open 5 minutes ago, and now I'm not able to get into it...the file is in the same directory as 00Timecard.xls...guess this means my team leader won't be getting my timesheet in the near future! *smirk*
Unless someone is aware of a bug in excel where you save the file and it gets corrupted...???
0
 
LVL 1

Expert Comment

by:EvanL
ID: 1602674
check for a .tmp file of it in your windows\temp directory.. maybe you can open it, cut and paste the data into a new Excel file and delete the old one.  I find that Excel files can get corrupted easily and then they are permanantly hosed.
0
 

Expert Comment

by:Lupen
ID: 1602675
make sure you are the only one opening the file...if someone else is already accessing it,it sometimes gives errors saying that it cannot access it
0
 
LVL 3

Accepted Solution

by:
frazer earned 50 total points
ID: 1602676
Hi,

It sounds like your file is corrupted,

run scandisk and then defrag,

if anything is going to cure your problem this will.

Hope this helps

Frazer
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
This article will show you how to use shortcut menus in the Access run-time environment.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now