Database "X" is read-only

[John]

Hi,

I have 2 pc with Windows XP Home and an Access database, which is split in
front and back end.

the backend sits on one PC in a folder that is shared (and the"other people
can change my files option has been checked). I changed the file and folder
attrib to -r.

Set up a user on one PC as well as the other hoping that a login would occur.

But the database remains read-only.

Any suggestions? txs a lot.

John

 

[TC]

Each windows user who uses the database, must have full permissions
(create/update/read/write/delete) to the folder containing the common
BE, and the folder containing their own copy of the FE.

HTH,
TC

 

[John]

Hi TC,

Thanks for your response.

What you suggested I have tried. I think it has something to do with the be
database being locked exclusively, but have no idea as to how and why.

John

 

[TC]

You say that you changed some attributes to "-r" - wouldn't that only
be Read access? What about Create, Write, Edit and Delete access? You
need /all/ of those are required, on all of the relevant files &
folders, for every windows user who will run the system. If you haven't
set all of those correctly, this could explain the db openening for
read only.

If you haven't already done so, you should also check the read-only
checkbox in the BE & FE right-click properties.

HTH,
TC