Re: Keep losing user permissions on Access multiuser application

From: TC (aatcbbtccctc_at_yahoo.com)
Date: 02/17/05 

Date: 16 Feb 2005 19:11:20 -0800

insecure wrote:

> Using Access 2000, I've got a multiuser application set up on a
server.
> I also have a development version set up in a different
subdirectory.

I assume you have split the application into a "front end/back end"
structure? And you have a seperate copy of the FE for each user? If
not, you have a significantly suboptimal setup, & you should really fix
that issue before you continue with the permissions one.

> Whenever I copy the development version over the production version,
I
> tend to lose some access rights for some users, for sure on several
> tables.

If you assign a user some rights to an object, and there is a user with
precisely the same name *and PID* in a different MDW, the latter user
will automatically acquire those rights to that object. If this does
not occur, then, some condition stated in the preceding sentence is not
present.

> It seems like this might also happen when I go in and view the
> permissions on the production version while it is being used.

Are you saying that "viewing" permissions causes them to disappear? Not
likely, IMO.

> I use a copy of the MDW file in the development subdirectory, which I
> refresh sometimes from the production directory.
>
> Anyone know what I can do about this? Is this a problem with version
> 2K only?

It is a problem with what you are doing - not with Access. Properly
assigned permissions do not just "disappear" :-)

To get more help, you'll probably need to provide more details on
exactly what you are doing. For example:
1. using MDW #1, I creat a new table T, and assign Read Access on that
table, to user Fred;
2. I then copy db1.mdb containing that new table, to db2.mdb.
and so on.

HTH,
TC

Relevant Pages

  • Re: Prevent changes to Administrator password
    ... What I am trying to do is give Taz1972 some options to minimize the risk or make it harder for a lower-level DA to reset the password for the EA account. ... Restricted Admins group to mitigate against what you propose Deji. ... also need to make sure the DAs in question cannot elevate their rights to EA, ... > By adding the Deny Write Permissions ACE, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Prevent changes to Administrator password
    ... What I am trying to do is give Taz1972 some options to minimize the risk or make it harder for a lower-level DA to reset the password for the EA account. ... * This posting is provided "AS IS" with no warranties and confers no rights! ... > By adding the Deny Write Permissions ACE, ... > permission to modify the ACL on AdminSDHolder. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Prevent changes to Administrator password
    ... Have you thought about delegating the exact permissions needed instead of using DA or restructing your forest? ... * This posting is provided "AS IS" with no warranties and confers no rights! ... > Restricted Admins group to mitigate against what you propose Deji. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Why is Fedora not a Free GNU/Linux distributions?
    ... Taking away legitimate rights, yes, that would be immoral. ... specifically to be incompatible with the GPL, ... Software license) doesn't take away any right you had. ... There are other permissions that enable you to copy and distribute the ...
    (Fedora)
  • Re: Prevent changes to Administrator password
    ... * This posting is provided "AS IS" with no warranties and confers no rights! ... his/her account from the Restricted Admin group and clears the flag? ... > By adding the Deny Write Permissions ACE, ... > permission to modify the ACL on AdminSDHolder. ...
    (microsoft.public.windows.server.active_directory)