Access Database - Read Only

[realtallgal]

For some reason my database on the LAN keeps reverting to read only.. I will be in it one minute, close it, then go back into it and it says that it is READ ONLY.. is there a feature that i have on that I don't realize that is causing this? Please advise.

 

[Remou]

If you are compacting and repairing, it may be inheriting permission from the directory, as far as I recall.

http://lessthandot.com

 

[realtallgal]

I am not repairing or compating. A user will go in first thing in the morning and it will be read only.. any suggestion how to fix it?

 

[PHV]

The user should have sufficient credentials on the LAN share to remove the .ldb file.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[realtallgal]

What is the .ldb file?

 

[Remou]

The ldb file is the lock file created by Access. All users must have full permissions on the back-end and front-end folders.

http://lessthandot.com

 

[dhookom]

I like to think of the ldb file as the "lights". The lights are in the "records" room in Access. Every user must have the permissions to both turn on the lights (create the ldb) and turn off the lights (delete the ldb).

When the first user opens your mdb, he turns on the lights (creates the ldb). This allows all users to be able to see which records are being edited. Other users can then safely edit, create, and delete records. If the first user in the room can't turn on the lights, then additional users won't have a clue regarding which records are being accessed and won't be able to turn on the lights. The mdb will be read-only.

When the last user exits the room, he turns off the lights (deletes the ldb).

This is a bit simplified but might explain your issues.


Duane
Hook'D on Access
MS Access MVP