Keep losing user permissions on Access multiuser application

[insecure]

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.

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.

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

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?

 

[TC]

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