"Read-Only" Frustration

[Guest]

I have numerous MSAccess 2000/2002 databases where the back end is on our
network and users have a local front end. Most of them work fine in the
sense that multiple users can write to the database at the same time as long
as they're not hitting the same record.

A couple, however, go into "Read Only" mode as soon as anybody launches
their copy of the front end, which prevents me from doing housekeeping
things. I've looked and looked at the database properties, Tools-Security
settings, etc., and can't see what's different about these particular
databases. I must be missing something simple; can anybody help?

 

[Joan Wild]

A couple, however, go into "Read Only" mode as soon as anybody
launches their copy of the front end, which prevents me from doing
housekeeping things. I've looked and looked at the database

It could be the windows permissions on the folder where the backend(s) are.
All users need read/write/modify/delete permission on the folder.

Other possibilities:
Backend is set to open exclusive (Tools, Options, Advanced) instead of
shared.
There is code in the frontend that is opening the backend exclusively.

I'd bet it's folder permissions though.