How do I copy a database to a CD so that it is not read-only?

  • Thread starter Thread starter sushi10w
  • Start date Start date
S

sushi10w

I'm not very sophisticated when it comes to Access so
please can some one help!!?? I'm trying to make a copy of
my db's using Roxio CD Creator 5 and they are always saved
as "read-only" and that doesn't do me any good as I need
to make saveable changes on the CD version. Please tell
me how to do this!!!!
 
As far as I know, you cannot. You will need to make your database changes
on the hard drive of your computer.
 
Not sure that I quite understand the question...

You can't save changes to a CD! They are read-only.
Even if you are saving to a CD-RW (Re-writable CD), I don't think trying to
save changes from Access directly back to the CD is a good idea, writing to
a CD is many many time slower than writing to a normal disk, and anyway, my
understanding of CDs is that you would write a new copy of the file, not
alter an existing one. I don't really see how this could work...<feel free,
somone, to prove me wrong>

All I can suggest is you copy the DB off your CD, make the changes, then
burn a new CD with the updated DB on it.

When you copy the file off a CD back onto a computer, it might make the
computer version read-only.
You can change that by right-clicking on the file in file-explorer,
selecting 'Properties' and un-checking the 'Read Only' box.

Cheers,

ChrisM
 
Thanks Chris for your help - here's my situation and maybe
you can give advice: I am leaving my place of employment
and the computer is my own personal computer and I want to
leave the databases for this specific employer on disc for
the next person coming in - I'm taking my computer with
me. The next person will have to be able to manipulate
the databases and make changes, etc. and then they can
save the info to their own hard drive. Maybe this makes
things clearer - I'm not sure how to do this for them.
 
Thanks Cheryl for your help - here's my situation and
maybe you can give advice: I am leaving my place of
employment and the computer is my own personal computer
and I want to leave the databases for this specific
employer on disc for the next person coming in - I'm
taking my computer with me. The next person will have to
be able to manipulate the databases and make changes, etc.
and then they can save the info to their own hard drive.
Maybe this makes things clearer - I'm not sure how to do
this for them.
 
I agree that you should leave a copy of all your databases on a CD for your
employer to give to the next employee, as this gives your employer (and you)
an uneditable snapshot of the work as it existed when you left employment.

However, I do not understand why you feel that this new employee must
"manipulate the databases and make changes" on the CD and *then* copy the
database to his or her own hard drive. That seems to me to be the reverse
of the order in which steps should be taken. The new employee should copy
the database to his or her computer, make changes and, at appropriate
intervals of time save copies of the database to a CD for backup purposes.

In addition, to expand on my earlier posting, it is the normal and expected
behavior for an Access database to become Read-Only when copied to a CD.
As a matter of fact, I currently have a rewriteable CD in my drive; and,
while the CD itself is RW, the Access database which has been copied to it
is Read-Only.
 
Instead of writing the database to a CD you might consider using something
like an externl ZIP drive. They provide a R/W medium.

Jonathan
 
Hi

That files (not only Access Databases) are set to read-only is absolutely normal
CD-Rs : You can only write once and read many times, you can't change files burned on CD-Rs
CR-RW : You can burn files on them, delete them, burn them on it again, etc. but you can't change them while they are on the disk

Some CD-Burning programs bring a tool with them with which you are able to handle CD-RW like normal harddisks (write, change, delete, the whole programm). The bad thing with this is, that everybody who needs to read, etc. the CD needs this tool installed on the PC, without it : no chance. Unfortunately I don't know Roxio CD Creator if it contains a tool like this

Regards
Bernd
 
The purpose of burning to a CD is to store the data. To
use a copy on CD copy it to your PC and go to properties.
Uncheck the read only box. Then the DB can be modified/Used

Jim
 
When the new person grabs that cd..then they can simply move the mdb files
on to a cmputer.

You then right click on those files (on the compter)..and un-check the
read-only flag.
 
Back
Top