Access 2000 Security Object Documenting, please help!

18 Oct 2005 8:23 PM

googlejunk

Hello Fellow NewGroupies...:)

I have an access 2000 database that I have been trying to find a way to
be able to see what groups have rights to what object. I know that
there is the microsoft documenter. However, I have over 500 objects in
this database in total, so the report took forever to run, and ends up
being over 2000 pages in length.

Ideally, I had hoped to sift around and find a utility/add-in, but
there doesn't appear to be one.

I'd like it to be a little more useful. I don't need to know every
user in my database, etc. What would be even best is to list the first
group and all the objects they can edit, delete, etc., then the second
and so on.

Any help, would be much appreciated.

Thanks

19 Oct 2005 1:58 AM

Jeff Conrad

I have an add-in that will print out the security on objects. It will
save a few forests over the documenter as well. You can find the
free add-in on MVP Sandra Daigle's site here:

http://www.daiglenet.com/msaccess.htm

Look for the first two items listed (the DBUtilties add-in). I'm
working on improving it, but it should get you pretty close to
what you want right now.

Please make sure you read the Word document first and make
backups!

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

<googlej***@computunity.com> wrote in message:

Show quoteHide quote

news:1129666996.313508.74520@g44g2000cwa.googlegroups.com...

> Hello Fellow NewGroupies...:)
>
> I have an access 2000 database that I have been trying to find a way to
> be able to see what groups have rights to what object. I know that
> there is the microsoft documenter. However, I have over 500 objects in
> this database in total, so the report took forever to run, and ends up
> being over 2000 pages in length.
>
> Ideally, I had hoped to sift around and find a utility/add-in, but
> there doesn't appear to be one.
>
> I'd like it to be a little more useful. I don't need to know every
> user in my database, etc. What would be even best is to list the first
> group and all the objects they can edit, delete, etc., then the second
> and so on.

19 Oct 2005 7:42 PM

Cy

Thanks. While it doesn't do exactly what I need, I think it get's me
close.

19 Oct 2005 7:48 PM

Jeff Conrad

You're welcome, glad to help.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

"Cy" wrote in message:

Show quoteHide quote

news:1129750946.726817.161030@g44g2000cwa.googlegroups.com...

> Thanks. While it doesn't do exactly what I need, I think it get's me close.

19 Oct 2005 3:52 PM

Jack MacDonald

Here is an A97 utility -- it may work in A2000

http://www.mile50.com/access/ptrack/

On 18 Oct 2005 13:23:16 -0700, googlej***@computunity.com wrote:

Show quoteHide quote

>Hello Fellow NewGroupies...:)
>
>I have an access 2000 database that I have been trying to find a way to
>be able to see what groups have rights to what object. I know that
>there is the microsoft documenter. However, I have over 500 objects in
>this database in total, so the report took forever to run, and ends up
>being over 2000 pages in length.
>
>Ideally, I had hoped to sift around and find a utility/add-in, but
>there doesn't appear to be one.
>
>I'd like it to be a little more useful. I don't need to know every
>user in my database, etc. What would be even best is to list the first
>group and all the objects they can edit, delete, etc., then the second
>and so on.
>
>Any help, would be much appreciated.
>
>Thanks

**********************
jackmacMACdon***@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

19 Oct 2005 7:46 PM

Cy

Couldn't get it to read in Access 2000. Looks like it would do
everything I'd need and then some. Do you know if they created a 2000
version? I looked, but couldn't find one?

Thanks

20 Oct 2005 11:22 PM

Chris Mills

See if this helps
http://www.grahamwideman.com/gw/tech/access/permexpl/index.htm

Chris

<googlej***@computunity.com> wrote in message
Show quoteHide quote

> Hello Fellow NewGroupies...:)
>
> I have an access 2000 database that I have been trying to find a way to
> be able to see what groups have rights to what object. I know that
> there is the microsoft documenter. However, I have over 500 objects in
> this database in total, so the report took forever to run, and ends up
> being over 2000 pages in length.
>
> Ideally, I had hoped to sift around and find a utility/add-in, but
> there doesn't appear to be one.
>
> I'd like it to be a little more useful. I don't need to know every
> user in my database, etc. What would be even best is to list the first
> group and all the objects they can edit, delete, etc., then the second
> and so on.
>
> Any help, would be much appreciated.
>
> Thanks
>