Burning CD

Created database table, form and reports. Need to transport entire file to
various job sites. When I burn the file to a CD - it always ends up as a
"read only". The permissions are not set to this. This doesn't happen with
any other file other than an Access Database. Suggestions????

In order to use a database, you have to write to the folder in which the
database lives. You can't write to a CD, so it is read-only. Unlike a Word
document or spreadhseet, Access writes AS you make changes (and even creates
a temporary file just by opening the database). With Word, or Excel, you
would not get this type of warning until you tried to save the document,
then you could select a new path. Access does not work that way.

Rick B




"mrs. s" mrs. wrote in message
...
Created database table, form and reports. Need to transport entire file
to
various job sites. When I burn the file to a CD - it always ends up as a
"read only". The permissions are not set to this. This doesn't happen
with
any other file other than an Access Database. Suggestions????

To add to what Rick mentioned, you can always copy the file off of the CD at
your destination, then view the properties of that file and uncheck the
read-only property, making the database copy useable again. You just can't
change it on the CD, since a CD is read-only by its nature. You may want to
try burning to a CD-RW, it may not set the read-only property (I haven't
tried this so I don't know). Or, you could copy it to some other type of
medium (compact flash, USB hard drive, etc) if you do this all the time and
don't want to have to hassle with resetting the read-only property.

-Ted Allen

"Rick B" wrote:

In order to use a database, you have to write to the folder in which the
database lives. You can't write to a CD, so it is read-only. Unlike a Word
document or spreadhseet, Access writes AS you make changes (and even creates
a temporary file just by opening the database). With Word, or Excel, you
would not get this type of warning until you tried to save the document,
then you could select a new path. Access does not work that way.

Rick B




"mrs. s" mrs. wrote in message
...
Created database table, form and reports. Need to transport entire file
to
various job sites. When I burn the file to a CD - it always ends up as a
"read only". The permissions are not set to this. This doesn't happen
with
any other file other than an Access Database. Suggestions????

Hi Mrs S,

That's the way it is. After copying the file from the CD to the other
machine's hard disk, just use My Computer or Windows Explorer to
navigate to the file, right click on it, select Properties, and turn off
Read Only.

On Thu, 21 Oct 2004 11:29:03 -0700, mrs. s mrs.
wrote:

Created database table, form and reports. Need to transport entire file to
various job sites. When I burn the file to a CD - it always ends up as a
"read only". The permissions are not set to this. This doesn't happen with
any other file other than an Access Database. Suggestions????

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.