Database is read-only

  • Thread starter Thread starter Tom P.
  • Start date Start date
T

Tom P.

Not sure this belongs in this newsgroup...

I have an Access 2000 database that is on a file server
and is now telling me it is read-only whenever I try to
open it. I can't even change data in the tables. The
properties of the file do not indicate that it is read-
only and there is no LDB file so I don't believe anyone
else has it open.

I'm guessing I did something where a Word mail-merge
crashed and did not disconnece cleanly from the database
or perhaps a VB ADO connection I made did something
funky. I rebooted my PC to see if I was the person
connected but this made no difference.

How can I tell what has this file in use? Is there a way
for me to kill the link blindly if need be?
 
The fact that there is no ldb file suggests you are opening it exclusively.
Even with one user, the ldb file is created.

Perhaps you or other users do not have create permissions on the folder
where the mdb is. If so then the first person in won't be able to create
the ldb and the mdb will be opened exclusively.

All users need modify permission on the folder (read, write, create,
delete).
 
Thanks. I do have full permissions on the folder so I'm
not sure what the deal is. Finally today the file has
lost its read-only tag and is back to normal. Whatever
was holding onto it must have finally let go. Thanks for
the reply. - Tom
 
Tom P. said:
Thanks. I do have full permissions on the folder so I'm
not sure what the deal is.
Click to expand...

It might have been some other user that didn't have full permission.

Finally today the file has
lost its read-only tag and is back to normal. Whatever
was holding onto it must have finally let go. Thanks for
the reply. - Tom
Click to expand...

Glad it's sorted.
 
Back
Top