<div>
peter57r is right and here is a way to do it. &nbsp;If you are signed in to the .mdw file you do this:<br />
<br />
Public Sub EnumerateUsr_Grps()<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Set WrkSp = DBEngine.Workspaces(0)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; For Each New_User In WrkSp.Users<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Debug.Print New_User.Name<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; For Each GroupMem In New_User.Groups<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Debug.Print &quot;&nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp;&amp; GroupMem.Name<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Next<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Next<br />
<br />
End Sub<br />

</div>


peter57r is right and here is a way to do it.  If you are signed in to the .mdw file you do this:

Public Sub EnumerateUsr_Grps()
               
                Set WrkSp = DBEngine.Workspaces(0)
                For Each New_User In WrkSp.Users
                    'Debug.Print New_User.Name
                    For Each GroupMem In New_User.Groups
                        'Debug.Print "        " & GroupMem.Name
                    Next
                Next

End Sub


<div>
You can also use the same .mdw file for as many databases as you like. &nbsp;Just login into any database as an administrator and join the workgroup. &nbsp;In Access 2k3 it's Tools&gt;Security&gt;workgroup administrator
</div>


You can also use the same .mdw file for as many databases as you like.  Just login into any database as an administrator and join the workgroup.  In Access 2k3 it's Tools>Security>workgroup administrator

<div>
<div class="content wysiwyg-content">
How do I enumerate the user names in an mdw file for a database external to the one I am currrently in?
</div>
</div>


How do I enumerate the user names in an mdw file for a database external to the one I am currrently in?

Groups and Users in an MDB outisde the currentdb

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.