unable to access read-only access database

[OM]

Hi,

I have an access database shared on the network. There are 2 levels of
permission on the folder where the database is resided, read and
read/write. My problem is that people with read access to the folder is
unable to access the database and it complained that it can not lock
file whenever they tried to access it. The only way to fix it is to
allow read/write access to the folder.

I don't understanding why read access user still need to create lock
file even though they are not going to write to it. Can someone advice
how to resolve this problem?

Thanks

 

[Golfinray]

You have several issues. 1. ALL users on the network must have
read/write/modify/and delete priviledges on the network or they cannot unlock
the lock file to gain access. 2. You should split your database and have a
front end and backend if you don't already. Then you put the BE (all the
tables) on the network drive and the FE on EACH users computer. They need the
FE on their hard drive with a shortcut to it. Then users can have their own
forms, reports, but still pull data from the tables. 3. The FOLDER the BE
resides in must also allow priviledges becasue ACCESS has to have rights to
create temp files. Read the help files on splitting your database.