Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why is CDROM copy Read-Only? 2

Status
Not open for further replies.

Ricky1946

Programmer
Jul 11, 2001
76
GB
Why is the copy of an Access database that I saved onto CD-ROM Read-Only when copied onto another hard drive? If the same file is saved to floppy disc it is not. Does anybody know how to overcome this?
Looking forward to hearing from you.
Regards
Ian Richards "To say 'thankyou' encourages others."
 
Oddly enough I had this problem just yesterday. I got round it by creating a new blank db and importing the entire read-only one into it. There are probably other (and possibly better) ways of doing this, but it worked for me!

There are two ways to write error-free programs; only the third one works.
 
After copieg back to a hard disk, right click on the file, select properties and take off the read only attribute. [pc]

Graham
 
Thanks GHolden and Graham,
Yes, I think you have it Graham. I was trying to take off the Read-only from WITHIN the database and not from the file name.
Thanks a lot.
Ian "To say 'thankyou' encourages others."
 
Cheer Graham, I tried to do the same as Ian.

There are two ways to write error-free programs; only the third one works.
 
Another way to avoid this "read-only" issue is to Zip the DB before burning.

Then when you uncompress the files they maintain their original attributes.

Regards,

Peter Remember- It's nice to be important,
but it's important to be nice :)
 
I didn't know that Peter. Thanks I will take note of that.
Ian "To say 'thankyou' encourages others."
 
Any file burned to a cd-rom automatically has its attributes altered to read only. It is the nature of a cd-rom. As on the CD-Rom you can't do anything but read it.

Rick
 
Hmmm yes!
Point taken!
Ian

"To say 'thankyou' encourages others."
 
Hello Ian and Others

It does gets better. I'm developing with Access 2002, SP-2 on Win XP Home for a system running Access 2000 SP-3 on Win 98. When I transfer to Access 2000 I get the read-only attribute set. When I transfer back home 2002/XP is smart enough to take off the attribute for me.

Regards
Dave
 
Hey Guys,

I believe Microsoft finally got it right.

In Windows XP Professional, when I copy files from a CD, the Read-Only attribute gets cleared when the file is copied to the hard drive.

So, let's See,
Win 95 Strike 1
Win 98 Strike 2
Win NT Strike 3
Win 2000 Strike 4
Win Me Strike 5
and then finally
Win XP Pro, and I do not have to right click and reset the Read Only Attribute.

Imagine if a baseball batter got 6 strikes.

Enjoy,
Hap [2thumbsup]


Access Add-on developer [pc] - [americanflag]
 
this snippet of code will remove the read only attribute from the current .mdb file
If GetAttr(CurrentProject.FullName) > 0 Then
SetAttr CurrentProject.FullName, GetAttr(CurrentProject.FullName) - 1
End If
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top