How do I remove Read Only from DB

[Guest]

I have an existing DB that has all the sudden become read only. Yesterday it
worked fine so I went to the Back up from yesterday and it's the same. Any
suggestions?

 

[John Vinson]

On Tue, 21 Nov 2006 09:43:02 -0800, Remove Read Only <Remove Read

I have an existing DB that has all the sudden become read only. Yesterday it
worked fine so I went to the Back up from yesterday and it's the same. Any
suggestions?

First thing to try: Open Windows Explorer (My Computer); navigate to
the folder containing the database .mdb file; right mouseclick it and
view its Properties. Uncheck the Read Only checkbox. If the file were
copied from a CD it will be marked read-only, and this is the way to
clear that.

It's also possible that your permissions have been changed on the
folder containing the database - you need full read, write, create and
delete privilege (in order for Access to create and delete the .ldb
locking file).

John W. Vinson[MVP]

 

[Guest]

Thanks John, the permissions were corrupt.

On Tue, 21 Nov 2006 09:43:02 -0800, Remove Read Only <Remove Read



First thing to try: Open Windows Explorer (My Computer); navigate to
the folder containing the database .mdb file; right mouseclick it and
view its Properties. Uncheck the Read Only checkbox. If the file were
copied from a CD it will be marked read-only, and this is the way to
clear that.

It's also possible that your permissions have been changed on the
folder containing the database - you need full read, write, create and
delete privilege (in order for Access to create and delete the .ldb
locking file).

John W. Vinson[MVP]