Making changes to a read-only database?

  • Thread starter GoingDatabaseCrazy
  • Start date
G

GoingDatabaseCrazy

I have recently inherited the responsibility of maintaining a database
created by someone else who is no longer here. The database file is
Read-Only, and I have been unable so far to modify the properties so I can
make edits. Is this possible, or does the database need to be re-created
from scratch?

Thanks
 
K

Klatuu

Open Windows explorer and navigate to the mdb file that is read only.
Right click and select Properties and UnCheck the Read Only property.
 
G

GoingDatabaseCrazy

I've tried this, and I get an error message saying my access is denied...
 
J

Jeff Boyce

There may be a difference of definition...

A file can be 'marked' as Read-Only. Dave's response explains how to change
this.

The database may have been saved as an .MDE file (instead of an .MDB file).
If this is the case, you need the original .MDB file from which the .MDE was
created -- you cannot change the .MDE -- that's why it was created (to
prevent changes)!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

Klatuu

You will have to talk to your system administrator. This is the only way to
accomplish this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top