Urgent - Read-Only backup copy

  • Thread starter Thread starter jb
  • Start date Start date
J

jb

A friend sent me a backup disk of an Access 2000 mailing
list database. He needs records selected and sent to a
mailing house early Monday morning, and this is the only
copy of the database he can get me. I want to create a
query, but I can't - the .mdb is READ ONLY, and almost
all the functions are greyed out. In any case, I can't
save any changes. What's the fastes way to work around
this? I figure, duplicate this database in a readable
format and work from that. But I can't replicate it, copy
it, nothing seems to work. It's been years since I've
used Access - my version is 20.2695,2605m from the Office
XP Professional suite.
 
When a file is put on a CD, Windows automatically sets its "readonly"
property to Yes.

After you copy the file onto your hard drive, open Windows Explorer,
navigate to the file, click on it, open Properties window, and deselect
Readonly setting.
 
All, and any files copied from a cd rom (ROM = Read Only Memory) are thus
marked as read only. So, copy the file off the media, and then right click
on the file, and un-check the read-only setting for the file.

This problem will occur for any file, and is not just ms-access problem . If
you copy a word file from the cd rom, it also will be read-only and cannot
be modified until you un-check the read only flag.

You are likely new to computers, or certainly new to using computer with a
cd-rom.

You could also have just created a new blank database, and imported the
tables etc into the new database from the cd.

Good luck...
 
Van T. Dinh said:
Hi Ken

We may have to be a bit more selective in the future. I found that when I
use WXP Explorer to copy files onto the CD (physically copy, NOT marked to
be copied) and when I copy these files back to the hard-disk, they are not
marked as "Read-Only".
Click to expand...


I'm still on Windows 98SE, so I can't speak to this! < g >
 
Thanks. I'm not at all new to computers or databases,
but I haven't used CDRW's much yet, and I'm very rusty on
Access and unfamiliar with the new version. But that's
improved a lot in the last couple of hours.

The first thing I tried to do was copy the file from
the CD, but I got an "access denied" message. I tried to
reset the Read Only property on the original either, but
it was greyed out or something. Very confusing, and
that's when I posted the message.

While waiting. I created a new database and copied over
the table. I was resisting doing that because I wanted
the forms, etc, too. But it's been workable enough. I've
been learning how to work the new interface to get
queried/filtered data.

All the "user friendly" bells and whistles of Access
2002 are entertaining, and I'm sure a lot of Microsoft
techies enjoyed developing them. But it would be a hell
of a lot simpler and more elegant to just write
"COPY ALL FOR ZIP >="10400"
..AND. ZIP <= "15000"
..AND. LastDonateDate < CTOD "06/01/2003")
..AND..NOT. "NOSOLICIT"
at a dot prompt.

Thanks anyway for replying so quickly.
jb
 
You can import all the objects (tables, queries, forms, reports, modules,
pages, and macros) from one databse to another. Open the new database, go to
File | Get External Data | Import, and select the original database. You
then can choose any of these objects for importing into your new database.
They'll then be copied into the new database.
 
Back
Top