Re: Obtaining Permiissions for User and Groups via VBA

Tech-Archive recommends: Speed Up your PC by fixing your registry

Check out http://www.mile50.com/access/ptrack/index.htm for a free
utility for documenting database permissions. Note that permissions
are stored in the *database file*, not in in the workgroup.

On Mon, 18 Jul 2005 13:57:01 -0700, "rj_budz"
<rjbudz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hi all,
>
>I found code to obtain User Names, Groups, Users in Groups, and Groups By
>User, all done in VBA. So now I can see (and export to Excel) what's what in
>my application's system.mdw.
>
>I would like to programmatically get a list of the privileges granted to all
>groups and users.
>
>This seems like it would be a very useful thing to have on hand outside the
>database, in case of emergency (allong with the PINs for each user).
>
>Does anyone know how this can be done?
>
>rjbudz


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

Relevant Pages

  • Re: Activate different FE apps
    ... See http://www.QBuilt.com for all your database needs. ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... Database files need workgroup files, but they don't really "link" to them. ... commonly a Windows shortcut is used to open the database file while joined ...
    (microsoft.public.access.security)
  • Re: master password for access
    ... then the security would not be of much use. ... workgroup, or one without any passwords set up. ... but never bother to actually secure the database file. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: how to deploy a secure db to LAN
    ... One needs to be joined to the secure workgroup before the database file is ...
    (microsoft.public.access.security)
  • Re: ".Groups()" Collection Item not found (3265) on one of several computers only
    ... It exists in every Workgroup, but the text string being passed may not ... See http://www.QBuilt.com for all your database needs. ... Explicit" and "Require Variable Declaration" were good tips I knew ...
    (microsoft.public.access.security)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... Yes, I can only guess but suspect that when the developers tried to incorporate OLE DB, they probably found themselves with a lot more problems than they bargained for and probably too little time to design a better way through them. ... For an OLE DB data source you really need a .udl or .odc file rather than a DSN. ... It can be hard to tell because you can't inspect long file names within the database name text box. ... Both OLE DB and ODBC connections from Word can also suffer from another problem - if the pathnames of the access database and the workgroup security database are too long, you may have problems when you try to connect, or more likely, when you try to re-open the mail merge main document. ...
    (microsoft.public.word.mailmerge.fields)