Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Making changes to a read-only database?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GoingDatabaseCrazy - 04 Dec 2007 18:26 GMT
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
Klatuu - 04 Dec 2007 19:01 GMT
Open Windows explorer and navigate to the mdb file that is read only.
Right click and select Properties and UnCheck the Read Only property.
Signature

Dave Hargis, Microsoft Access MVP

> I have recently inherited the responsibility of maintaining a database
> created by someone else who is no longer here.  The database file is
[quoted text clipped - 3 lines]
>
> Thanks
GoingDatabaseCrazy - 04 Dec 2007 19:05 GMT
I've tried this, and I get an error message saying my access is denied...

> Open Windows explorer and navigate to the mdb file that is read only.
> Right click and select Properties and UnCheck the Read Only property.
[quoted text clipped - 6 lines]
> >
> > Thanks
Klatuu - 04 Dec 2007 19:08 GMT
You will have to talk to your system administrator.  This is the only way to
accomplish this.
Signature

Dave Hargis, Microsoft Access MVP

> I've tried this, and I get an error message saying my access is denied...
>
[quoted text clipped - 8 lines]
> > >
> > > Thanks
Jeff Boyce - 04 Dec 2007 19:07 GMT
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

>I have recently inherited the responsibility of maintaining a database
> created by someone else who is no longer here.  The database file is
[quoted text clipped - 3 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.