Why my BE is opening Read-Only

[Dj]

I have a split database that I've been working on a while with just 3 users
while in the test mode. I rolled it out to the whole company this week and
I've been experiencing something, not consistant and very frustrating.

"Sometimes" the BE opens read-only and when it does, no data can be edited.
I can happen when just one person is in or more than one. It can happen when
you just open the backend; you actully see the "db is read-only" message.
However, it is not consistent. Sometimes it doesn't happen at all.

Can anyone clue me in on what is happening. Thanks! Dj

 

[Golfinray]

You may have several issues. 1. The users must have read/write/edit/delete
priviledges to the BE or they cannot open the lock file (the ldb.) 2. They
must have the same priviledges to the FOLDER the BE resides in because ACCESS
must be able to create temp files it needs. 3. Of course, the FE should be on
each users computer.

 

[Dj]

All users have read/write/edit/delete priviledges to both the BE and FE
folder. I haven't yet given everyone their own FE, but that can't be causing
the BE to open read-only when no-one is in the FE???

 

[Golfinray]

Yes, if all users try to use the one file, only one at a time will be able
to. Only when you split and give each user their own FE will all be able to
use it at one time. Read Joan Wild's "how to split a database" at
www.jmwild.com
By the way, I DON'T create an mde file when I split becasue I don't need any
additional security. My users don't go in and fool with the files or change
things anyway. You may need that, but if not, just ignore that part.

 

[Dj]

Thanks! I actually did create an MDE (I thought that alone would protect
from corruption, I now know differently and will make multiple copies of FE).

I'm still confused on the read-only issue because there are times when I go
into the BE and I'm the only one in there (I can tell watching for the LDB)
and when it opens, it says read only. 30 minutes later, I can try it again
and it opens up full access.

I'll distribute copies of the FE and see if that helps, but I'm somewhat
aprehensive that it won't make the read-only problem go away.

Thanks for your help.

 

[Golfinray]

Be absolutely sure that the IT guys give rights to that file AND folder and I
think you will be ok. Ray