 |
 |
Hello We have a 5000 record access database that only certain people should have access to. I've set permissions so that one group of users has read only access to the database directory, and the other group has write permissions to the database directory. However, when a user with read only access to the database directory tries to open the database, Access reports that it is 'unable to lock file'. I have tried starting Access with the /ro switch to open a database in read only mode, but this doesn't work. For some reason, one computer one the network this arrangement works fine, but none of the others will even open the database without write access. I realize I could put permissions in the database itself, but that's not something I want to do. Any ideas?