Access 2000 Security Object Documenting, please help!

[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

 

[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!

 

[Jack MacDonald]

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

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

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

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Cy]

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

 

[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

 

[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

in message:

 

[Chris Mills]

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

Chris