"Bruce Kovacs" <BruceKov***@discussions.microsoft.com> wrote in message
news:4FD65FB8-F40E-4F38-8DA3-B401667D714C@microsoft.com...

> Is there a way of printing or exporting the permissions assigned to database
> objects for each user group?  I am looking for an easier way to review and
> confirm the permission settings.  I have some databases with over 700
> objects.  Trying to use the Access Security Permissions window, which does
> not sort objects alphabetically, is very tedious.
>
> --
> Bruce Kovacs

"Jeff Conrad" wrote:

> The built in Documentor can do this for you.
> Details can be found here:
>
> http://www.access.qbuilt.com/html/security.html#DocSecPerms
>
> Be warned, the Documentor is not "paper-friendly" and
> will generate very long reports!
>
> A better way is to use my free Access Security Add-In
> which can print some nice security-related reports.
> It's primary purpose is to transfer permissions from one
> database to another, but the secondary purpose is to
> make some nice reports of object permissions and
> User/Group reports.
>
> You can find the download file here at the top of this page:
>
> "Sandra Daigle Permissions Wizard"
> http://www.daiglenet.com/msaccess.htm
>
> Read the Usage Guide before installing and using!
>
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
> "Bruce Kovacs" <BruceKov***@discussions.microsoft.com> wrote in message
> news:4FD65FB8-F40E-4F38-8DA3-B401667D714C@microsoft.com...
>
> > Is there a way of printing or exporting the permissions assigned to database
> > objects for each user group?  I am looking for an easier way to review and
> > confirm the permission settings.  I have some databases with over 700
> > objects.  Trying to use the Access Security Permissions window, which does
> > not sort objects alphabetically, is very tedious.
> >
> > --
> > Bruce Kovacs
>
>
>

"Jeff Conrad" wrote:

> "Bruce Kovacs" wrote in message:
> news:D65D8202-851A-4858-9DF8-3F771E456D63@microsoft.com...
>
> > Your add-in is just what I needed.  The detailed information report makes it
> > very easy to see which user group has which permissions.
> >
> > Thanks.
>
> Excellent!
> I'm glad you found my add-in useful.
> Thanks for the feedback!
> :-)
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
>
>

"Jeff Conrad" wrote:

> "Bruce Kovacs" wrote in message:
> news:7CEFF7EE-CCBB-4FC1-9B29-933C49C365BF@microsoft.com...
>
> > Late yesterday and this morning I started using your add-in for its stated
> > purpose, to transfer permissions to a new database.
> >
> > In my testing so far, the add-in works OK except that, for the the Database
> > and New object selections (New table, New form, etc.), it gives full
> > administer permissions to the Admins and Users usergroups.  That gives me
> > only a few things that I have to change, but I am wondering if I am doing
> > something wrong.
>
> You are not doing anything wrong Bruce; I have not incorporated that functionality
> into the add-in at this time. If you look on Page 7 in the walk-through section I
> mention this on Step 14. I did not, however, mention the new object selections and
> I probably should have. I will consider adding this feature.
>
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
>
>

"Jeff Conrad" wrote:

> "Bruce Kovacs" wrote in message:
> news:E080BC85-AC98-4DB4-A239-6E7D9D6F67CA@microsoft.com...
>
> > Jeff,
> >
> > I have been off on other things for the past week and am now getting back to
> > working with your add-in.
> >
> > This morning I made a new copy of my largest database (the one with about
> > 700 objects) and ran the add-in to transfer the permissions.  The progress
> > bar ran up to 90% and then I got an Error 6: Overflow message.  Is there a
> > limit to the number of objects and/or Usergroups the add-in can handle?
>
> Hi Bruce,
>
> Humm...that's interesting.
> To answer your question, I'm not sure exactly.
>
> The largest file I tested on had around 400 objects and never received a message like that. I will
> do some additional testing with larger files and see if I can reproduce the problem.
>
> A couple questions for you if I may. Did you receive the error when the progress bar was at 90% on
> the "Exporting" or "Importing" area? Which Access version are you using?
>
> Thanks for the information.
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
>
>

"Jeff Conrad" wrote:

> "Bruce Kovacs" wrote in message:
> news:E080BC85-AC98-4DB4-A239-6E7D9D6F67CA@microsoft.com...
>
> > Jeff,
> >
> > I have been off on other things for the past week and am now getting back to
> > working with your add-in.
> >
> > This morning I made a new copy of my largest database (the one with about
> > 700 objects) and ran the add-in to transfer the permissions.  The progress
> > bar ran up to 90% and then I got an Error 6: Overflow message.  Is there a
> > limit to the number of objects and/or Usergroups the add-in can handle?
>
> Hi Bruce,
>
> Humm...that's interesting.
> To answer your question, I'm not sure exactly.
>
> The largest file I tested on had around 400 objects and never received a message like that. I will
> do some additional testing with larger files and see if I can reproduce the problem.
>
> A couple questions for you if I may. Did you receive the error when the progress bar was at 90% on
> the "Exporting" or "Importing" area? Which Access version are you using?
>
> Thanks for the information.
> --
> Jeff Conrad
> Access Junkie
> Bend, Oregon
>
>
>

news:5D5F39D2-168F-43D4-9241-E9CFAD7DB575@microsoft.com...

> Jeff,
>
> I believe I solved my immediate problem using a bit of a work-around.
>
> I made a copy of my original database, and then deleted everything except
> the tables and queries.  This preserved the permission settings.  I then made
> another new database by importing the tables/links and queries from the first
> new database.  I then transferred the permissions for the tables and queries
> using the add-in (I got no overflow error messages this time).
>
> In my 2nd new database, I then massaged the permissions for the new objects
> (related to our previous discussion).  I then imported all of the remaining
> objects from the original database file to the 2nd new database file, where
> they inherited the permissions I had just established for new objects.
>
> Because I deploy .mde files, my main permission concerns are for the tables
> and queries, which transferred over just as I wanted.
>
> The bottom line is that I have successfully created a new, clean database
> file and preserved my original permission settings.  Not very elegant, but it
> worked!
>
> Thanks again.
>
> Bruce