Random READ-ONLY Setting Has Us Puzzled!!!

[Guest]

We are a small multi-user workgroup, using an Access 2003 database which
resides in a folder that all users have read/write access to. The database
attributes are NOT set to read-only.

At random moments of the day when you open the database it opens with the
error message "Database is read-only..." I go to check the attributes in
Explorer and the "read-only" attribute is still NOT checked. Sometimes I
close the database, re-boot, and the database is not longer read-only.

Does anyone know what could be causing this? It is killing us! Thanks!!!

 

[Rick B]

You say the users have read/write priveledges. What exactly can they do in
that folder? They need to be able to create an LDB file. Modify an
existing LDB file (that they may not own). Delete the ldb file when the
database is closed.

In short, they really need full access. If they have that, let us know.

 

[Guest]

Yes, all users have "FULL" access. THanks.

You say the users have read/write priveledges. What exactly can they do in
that folder? They need to be able to create an LDB file. Modify an
existing LDB file (that they may not own). Delete the ldb file when the
database is closed.

In short, they really need full access. If they have that, let us know.

 

[Guest]

I'm wondering if anyone has found a solution or cause for this problem as I
am experiencing something very similar. I've got a database which was
created with Access 2003. There are 5 users who update the database. 2
users have Access 2000 and 3 users have Access 2003. All users have full
access to the network location the database resides on. The majority of time
all users are able to use the database without any problems. Every once in a
while somebody will open the database and try to add a record and will get a
message that they are trying to add the record to a read only database. The
computer will then need to be rebooted in order to be able to add records
again. Any ideas why this is happening?