Read-Only Database Problems

[Guest]

I just got a new computer with Vista & loaded Office 2007 Pro on it. I
transfered my databases from the old computer to the new one.

Now there is one database ithat's Read-Only & it wants me to save it to
DOCUMENTS to make changes to it. This one database that HAS to live on the
Root of the C drive because another program that was designed just for us has
code written in it that refers thousands of times to this database on the
root of the C drive.

Is there some way to allow this database on the Root of C to change from
READ-ONLY to WRITE?

 

[Joseph Meehan]

I just got a new computer with Vista & loaded Office 2007 Pro on it.
I transfered my databases from the old computer to the new one.

Now there is one database ithat's Read-Only & it wants me to save it
to DOCUMENTS to make changes to it. This one database that HAS to
live on the Root of the C drive because another program that was
designed just for us has code written in it that refers thousands of
times to this database on the root of the C drive.

Is there some way to allow this database on the Root of C to change
from READ-ONLY to WRITE?

I know of no reason Access would have a problem and I know of no reason
Windows would have a problem, unless it was a change in the latest additions
which I do not have.

My guess is the file was copied to a CD to put it on the new computer and
that makes the file read only. You may Ned only change the file properties
and turn off read only.

 

[Guest]

Thanks Joseph, but it was transfered through the Files & Transfer program
that comes with Vista. All other databases that transferred work fine
because they are not stored on the Root of the C Drive (c:\databasename).
The first thing I did was go to properties to uncheck the "read-only" box,
but it wasn't even checked. I have tried several times to copy it, cut it,
change any permissions I can find to change to grant everyone in the world
full access to it, but nothing helps.

 

[Paul Shapiro]

Maybe the security on the C drive root prevents write access? To be able to
write in the db, the user obviously needs write permission on the db file
itself, but the user also needs to be able to create and delete files in
that folder, so the .ldb file can be created. If that can't be created, the
db will be read-only even though the user has write permission on the db
file. I don't know, but maybe Vista protects the root of the system/boot
drive? You could try right-clicking on C: in Windows Explorer and looking at
the security settings for the folder. There could be good security reasons
to protect the root of the system drive, and maybe that's why the default
changed in Vista.
Paul Shapiro

 

[Guest]

Thanks, Paul. I think that got me one step closer. I shared the C drive &
gave myself full permission. However, even after placing a new copy on the
root, it still opens in READ-ONLY.