Read Only permission to folder where database resides

A

Ally H.

We have an Access database stored in a network folder, we then have a number
of users with full permissions to this folder and some users with read-only
permissions. At present a user with read-only permissions only seems to be
able to open the database when no-one else has it open. If they do manage to
open it (i.e. no-one else in it at time) then it locks the file and non of
the other users can access it. If the file is already in use when a
read-only user tries to open it they get an Access error message "Can not
Lock File" Anyone any ideas. Weve tried the database using Access 2000 and
Access 2003.

TIA
Ally.
 
G

gandalf

if the user can't create the .ldb file the database will
be opened in exclusive mode

you will need to give them create/read/write/delete/change
permission.
 
A

Ally H.

What's the best way of going about making the data read-only for specific
users?

I do usually split the front end from the back, but not in this case as it
started out as a single user database but seems to have grown.

Ally.
 
Top