transferring security from one mdb to another...

[Brad Pears]

I have an access .mdb secured with a system file. In a recent project I made
significant changes to my development .mdb and simply want to use that .mdb
instead of importing all of the changes into the current "older" .mdb. If I
open the newly modified .mdb with a command line that directly indicates
the actual system file to use ... ie..

msaccess "c:\data\access projects\customer db\tnlhcdbenc.mdb" //wrkgrp
"\\true2\secdb\tnlhsecured.mdw"

it is not picking up the security at all from this .mdw (tnlhsecured)...

Is there a way I can quickly ensure my new .mdb will reference all of the
security I have set up in the original .mdb I used that is in the system
file??

Thanks,

Brad

 

[TC]

You misunderstand where the security goes.

The workgroup file does not know /anything/ about the database object
permissions. It only contains the user and group names, the user
passwords, and the user/group relationships - period.

The /database/ file contains the permissions, if any, that each user,
and group, has to each object in that database. Those permissions /are
not/ in the workgroup file.

So probably, the easiest way to get what you want, would be to open the
new database against the correct workgroup file, and re-establish the
permissions manually. Alternatively, there are some scripts that can be
used to transfer the permissions across - maybe google would find those
for you. But in my opinion, since you do not yet understand this
clearly, it would be better, as an educational exercise, to do them all
again from scratch

HTH,
TC

 

[Brad Pears]

Thanks for that... Yes, I was confused as to where that stuff was...