Database is ready only all of a sudden.

[Guest]

This is the first time I have ever used a discussion group to ask a question.
I've tried to get a hold of the man who wrote this program for me to see if
he could help but not getting an answer. I am desperate! I had a network
problem last week and after fixing it when I try to get into my database I am
being told that it is read only now. I have no idea how it could have
changed and do not know what to do to fix it. Can any help me with this. I
am not that knowledgeable about computers but I can certainly follow
directions. Pleaes!

 

[SusanV]

Check the NTFS and share permissions of the folder the db is in and the db
itself - they must BOTH be full control for users who will use the db.

 

[Guest]

Susan,
Sounding dumb here, what is the NTFS?
Michael

 

[John W. Vinson]

This is the first time I have ever used a discussion group to ask a question.
I've tried to get a hold of the man who wrote this program for me to see if
he could help but not getting an answer. I am desperate! I had a network
problem last week and after fixing it when I try to get into my database I am
being told that it is read only now. I have no idea how it could have
changed and do not know what to do to fix it. Can any help me with this. I
am not that knowledgeable about computers but I can certainly follow
directions. Pleaes!

Close Access; open "My Computer" or "Windows Explorer" to the folder
containing your database. Right mouseclick the filename and select
"Properties". If the Read Only checkbox is checked, uncheck it.

If it's not, then take a look at the Security property on both the database
and the folder containing the database. You must have full read, write, delete
and create permissions on the folder.

John W. Vinson [MVP]

 

[Guest]

Johm,
Thanks for your help. I tried that, going to the computer that has the
database. When I right mouse click and try to uncheck the check box I get a
window popping up that says "an error occurred applying attributes to
w:\data\blooms_be.mdb. Access is denied. I've tried hitting ignore, ignore
all, retry, everything it just doesn't work. Any other idea?
Thanks,
Michael

 

[John W. Vinson]

Thanks for your help. I tried that, going to the computer that has the
database. When I right mouse click and try to uncheck the check box I get a
window popping up that says "an error occurred applying attributes to
w:\data\blooms_be.mdb. Access is denied. I've tried hitting ignore, ignore
all, retry, everything it just doesn't work. Any other idea?

That suggests that you do not have Windows privileges on the folder. View the
properties *of the folder itself* - go up a level in the explorer - and check
the Security settings. Your account is evidently not privileged to change the
read-only property; you need at least that privilege, and in addition you need
read, write, delete and create privileges on the folder.

You may need to talk to whoever is in charge of Windows permissions, and
either get the permissions set on this folder or move the database to another
folder where you can have the permission.

John W. Vinson [MVP]