open db from readonly share

[aft3rgl0w]

Hey all, I can't seem to find a straight answer to my specific situation, so
I'm hoping someone can help. I work in a corporate environment where my
group uses an access 2003 db. My group has read/write access to the folder
containing the db. Everyone else outside our group has read only access to
this folder. Occasioanlly, people outside our group need to access info in
the db, but presently the only way they can even open the db is to copy is
locally first. if they try to run it off the read-only (to them) network
share they get a "could not lock file" error. I tried using a shortcut with
the /ro switch, but got the same problem. Is there a way users with
read-only access to this folder can open the db directly from the network in
RO mode without having to copy locally?
Thanks

 

[Chris O'C via AccessMonster.com]

No, *all* Access users need read, write and create privs on the folder where
the db file is if you want to avoid blocking users from opening the file.

They shouldn't be sharing the file anyway. Split the db into a front end and
back end, put the back end (tables and relationships) on the network share
and a copy of the front end (everything else and links to the tables) on each
user's desktop.

With Access user level security, you could have some of the users as "read
only" users within the db so they can't make changes, although the Windows
permissions are still read, write and create on the back end's folder.

Chris