reverting to read-only

[Guest]

A database I created is repeatedly opening as read-only whenever I put it on
my company server. It is only doing this on a computer that it was not
created on. When I open the file off the server from this comptuer (the one
it was created on) it opens fine. Although the file is opening as read-only
on the other computer, the read-only box is NOT checked in the file
properties.

Any help would greatly be appreciated.

 

[Rick Brandt]

A database I created is repeatedly opening as read-only whenever I
put it on my company server. It is only doing this on a computer that
it was not created on. When I open the file off the server from this
comptuer (the one it was created on) it opens fine. Although the file
is opening as read-only on the other computer, the read-only box is
NOT checked in the file properties.

Any help would greatly be appreciated.

Users need read, open, edit, create, and delete permissions on the folder where
the MDB resides or it will be read only. This is because a locking file (LDB)
needs to be created, managed, and deleted as users come and go.

 

[Guest]

When you say another computer does that computer (user) have the same
permissions as yourself?

Anyone you wish to open the file needs to have read,write,edit, and delete
permissions for the file/folder.

 

[Joseph Meehan]

A database I created is repeatedly opening as read-only whenever I
put it on my company server. It is only doing this on a computer that
it was not created on. When I open the file off the server from this
comptuer (the one it was created on) it opens fine. Although the file
is opening as read-only on the other computer, the read-only box is
NOT checked in the file properties.

Any help would greatly be appreciated.

I believe the others are correct in that whoever tires to open it must
have full permissions to that file and to the directory. However I will
make a couple of additional suggestions.

First could someone else already have it open?

Second did you copy it to the server by copying it on to a CD first? If
so the read only switch has been turned on and you need to change that. It
is a file property and you use the Windows tools to change it. (do a right
click on the mdb file)