How to copy Access database without read-only restriction

[Bruce Rollier]

I need to copy an Access database to a CD and from there to another computer.
When I create the CD, it always comes out as read-only, so I cannot create
queries or make table changes on the other computer. What is the setting for
copying it without this restriction? Thanks!

 

[Larry Linson]

I need to copy an Access database to a CD and from there to another
computer.
When I create the CD, it always comes out as read-only, so I cannot create
queries or make table changes on the other computer. What is the setting
for
copying it without this restriction? Thanks!

This is a Windows feature, and, AFAIK, there isn't an option to disregard
it. It seems to happen on machines I've used, with different versions of
Windows, whether the CD is ROM or RW, too.

The logic I can imagine is that when implemented, CD-RW were not in common
use, so they thought "a CD-ROM is always Read Only, so that will be the
default" but "when you copy a file to a hard drive, if it is Read Only, you
may want it to remain ReadOnly, so we won't change that". That is only
speculation on my part, but it's a possible scenario that would explain the
apparently-inconsistent treatment of the status of the files.

Larry Linson
Microsoft Access MVP

 

[Chris Reveille]

This happens when you create a CD. Copy the MDB from the cd to the other
computer.
In Explorer Right click on the file and choose properties. Remove the check

 

[David W. Fenton]

This is a Windows feature, and, AFAIK, there isn't an option to
disregard it. It seems to happen on machines I've used, with
different versions of Windows, whether the CD is ROM or RW, too.

The logic I can imagine is that when implemented, CD-RW were not
in common use, so they thought "a CD-ROM is always Read Only, so
that will be the default" but "when you copy a file to a hard
drive, if it is Read Only, you may want it to remain ReadOnly, so
we won't change that". That is only speculation on my part, but
it's a possible scenario that would explain the
apparently-inconsistent treatment of the status of the files.

Even CD-RW is really "read-only" because you can't really write to
the same sector twice. CD-RW is really just a multi-session disk.
You can't copy 650MBs to it, delete it and then copy 650MBs more,
because you can only use the sectors on the disk once. Thus, you
aren't really updating the original file image when you copy the
same file to it a second time. Instead, you're deleting the original
and creating a new read-only file.

 

[David W. Fenton]

This happens when you create a CD. Copy the MDB from the cd to
the other computer.
In Explorer Right click on the file and choose properties. Remove
the check on read only box.

Or, zip the MDB and copy the zip to the CD. Then you can extract
from the zip without needing to change the read-only flag.