J
Jeff Conrad
My latest Access MVP add-in is now available for download.
This one is called the "Sandra Daigle Permissions Wizard."
This add-in is NOT, I repeat, NOT a replacement for the built-in
Access security wizard. This add-in is intended for people who
already have a firm grasp of how to setup and use Access User
Level Security. If you do not understand ULS, do not use this add-in.
The add-in's primary purpose is to aid in transferring the object
permissions from a secured database to a new container with
the same (or nearly) structure.
There are times when it is necessary to import the database objects
into a new container. VBA code corruption, specific object corruption,
and even data corruption can make it essential to create a new empty
database container and import everything except the corrupted elements
to "start fresh." Also, during development many residual temporary
objects could be left "floating around" even after compacting a database.
Before deployment, I always believe it is a good idea to start with a nice
clean database container. However, when you import database objects
into a new container, all security permissions for those objects are lost.
I adapted Sandra's and Michka's code into an easy-to-use add-in that
will make this process much easier.
The add-in has supplemental features of creating very slick reports
of the object permissions by users, groups, or both. The Documentor
can kick out these types of reports as well, but my reports look
exactly like the options you see in the security permission screens.
And they use several trees less of paper! I also believe the reports
are more intuitive for users to understand. The add-in can also make
user, groups, and group membership reports from your workgroup file.
You can find the free add-in on MVP Sandra Daigle's site here:
http://www.daiglenet.com/msaccess.htm
(Right at the top)
There is one add-in that works for Access 97 and one that works
with Access 2000, 2002, and 2003. Make sure you download the
correct one for your Access version.
Inside the zip file is a very detailed Word document that explains
installation, usage, and a FAQ section. It would be a good idea
to review the document before playing around with it.
My extreme thanks to Sandra for posting the add-in on her site.
Hope you find useful.
Feedback is welcome.
This one is called the "Sandra Daigle Permissions Wizard."
This add-in is NOT, I repeat, NOT a replacement for the built-in
Access security wizard. This add-in is intended for people who
already have a firm grasp of how to setup and use Access User
Level Security. If you do not understand ULS, do not use this add-in.
The add-in's primary purpose is to aid in transferring the object
permissions from a secured database to a new container with
the same (or nearly) structure.
There are times when it is necessary to import the database objects
into a new container. VBA code corruption, specific object corruption,
and even data corruption can make it essential to create a new empty
database container and import everything except the corrupted elements
to "start fresh." Also, during development many residual temporary
objects could be left "floating around" even after compacting a database.
Before deployment, I always believe it is a good idea to start with a nice
clean database container. However, when you import database objects
into a new container, all security permissions for those objects are lost.
I adapted Sandra's and Michka's code into an easy-to-use add-in that
will make this process much easier.
The add-in has supplemental features of creating very slick reports
of the object permissions by users, groups, or both. The Documentor
can kick out these types of reports as well, but my reports look
exactly like the options you see in the security permission screens.
And they use several trees less of paper! I also believe the reports
are more intuitive for users to understand. The add-in can also make
user, groups, and group membership reports from your workgroup file.
You can find the free add-in on MVP Sandra Daigle's site here:
http://www.daiglenet.com/msaccess.htm
(Right at the top)
There is one add-in that works for Access 97 and one that works
with Access 2000, 2002, and 2003. Make sure you download the
correct one for your Access version.
Inside the zip file is a very detailed Word document that explains
installation, usage, and a FAQ section. It would be a good idea
to review the document before playing around with it.
My extreme thanks to Sandra for posting the add-in on her site.
Hope you find useful.
Feedback is welcome.