I have an access database on a shared network folder. This
database is used by mulitple users with full access to the shared
folder on the network. We have a new user that only has read
rights on the shared folder. Can I create a local database with
linked tables to the shared database for this individual without
changing his shared folder permissions?
It's not at all clear to me what you want.
The user in question is in a group that has read-only rights. That
will mean any files in the share will be read-only. If that's what
you want, then I just don't see what your question is.
To manage groups of users who need different rights on a share, you
create different user groups with different permissions provided for
the shares. It's better to create custom groups than it is to use
built-in groups (like users), because that gives you finer control
over who is a member (and still makes it possible to add large
groups of users in one fell swoop by simply adding their user group
as a member).
If, for instance, your Authenticated Users group has full
permission, but you want some people to have read-only, then create
a new user group (say "Read-Only Users") and apply DENY permission
to the folder for that user group on the create/modify/etc.
permissions. That will allow you to deny write to someone who is a
member of a default group and can't be removed (or who needs to be
in that group for other purposes). Remember, DENY permissions
override all other permissions (exactly the opposite of Jet
user-level security, BTW).
