Folder Permissions

[Katherine R]

I am trying to understand folder permissions. I have a split Access database
in a shared folder (Division XYZ folder) on a network drive. The back-end is
in a BE Data folder which is a subfolder of the Division folder. There are
different versions of the front-end. Each version of the fe is in its own
folder. For example, an agent's fe is in an Agent folder (also a subfolder
of the Division folder) and a supervisors fe is in a Supervisor's folder
(again, a subfolder of the Division folder). Users are instructed to drag a
copy of their front-end to their desktop. All fe's are linked to the same
be. I've asked our IT department to set up folder permissions giving
everyone full permissions to the Division XYZ foler and to the BE Data folder
and everyone full permissions to the Agent's folder. I've asked that the give
only supervisors full permissions to the Supervisor folder. Data is
accessible from the supervisor's fe database that other users should not see.
They told me that giving everyone full permissions to the Division folder
will cause everyone to have full permissions to all of its subfolders too,
including the supervisor folder. Is this correct?

 

[Larry Daugherty]

The answer to your direct question might be found in a newsgroup
devoted to the applicable operating system. FWIW the IT answer is
consistent with things I've been told before.

A solution to your problem might be to implement security in Access.
By using it, you can keep things under your control rather than
running into the red tape of requesting support from IT. There is a
newsgroup devoted to it: microsoft.public.access.security

HTH