Database Read Only. Help !!!

[Ayo]

We are having a very perculiar problem with an access database file. The file
is one the server and pretty much everyone can one it from the server except
for one particular person. And she is the one would needs this file because
she is responsible for update the database.
The file opens as "Database is read only" on her computer. She has R/W
access to the folder and the file is not protected, at least not yet, because
everyone else can open it without any problem.
Any ideas, as to the source of the issue? Any help will be greatly
appreciated. Thank you.

 

[Douglas J. Steele]

I've heard of cases where users have the ability to create files, and write
to the files they created, but they cannot write to files others created.
The user in question needs to be able to write to the locking file (LDB)
created by the first user to open the database. If she can't, Access will
treat the database as being read-only.

 

[Ayo]

Where, and what is this LDB (lockin file). The issue is that everyone esle
can open the file, she can open other file from the server. The problem
happens to be with this one file. That is what I am trying to figure out. Why
is this one file on this one computer having this problem.

 

[Douglas J. Steele]

See http://support.microsoft.com/kb/299373 While that particular KB article
only refers to Access 2002 and Access 2003, it's the same for all versions.

If she can open other MDB files, check for different permissions on the
different folders.

 

[Ayo]

The file was placed in the folder where she has R/W access to because she is
expected to be the only person responsible for updating the file. So I know
it is not a folder permission issue.

 

[John W. Vinson]

The file was placed in the folder where she has R/W access to because she is
expected to be the only person responsible for updating the file. So I know
it is not a folder permission issue.

She needs more: read, write, *CREATE* (to create the new .ldb file) and Delete
(if she wants the ldb file to go away when she closes Access).

John W. Vinson [MVP]