Linking to a Workgroup Information File

[CharlieT302]

Hello,

This originally was one small piece of another post. I am afraid it got lost in the shuffle so I wanted to have a dedicated post for it. I am using Access 2013 but our programs are designed and saved in a 2003 format. I want to be able to link and display the contents of two tables in an Access Workgroup Information File: MsysUserList and MsysGroupList.

I can open these directly from within the workgroup file, but I need to access them from with the database file itself. The reason is that we employ User Level security in our database. This is a must and cannot be altered.

I want the administrator to be able to:
[ul]
[li]Select a user from a list[/li]
[li]Select a security group from the group list and then assign it to the chosen user.[/li]
[/ul]

The external link procedure in Access will not link to an .mdw file. So, I am hoping for a programming solution.

 

[lameid]

Since it has been a while and no posts...

I forget the object model because Microsoft telegraphed killing security a while ago but there is a whole object tree devoted to security. I think you can loop over each of groups, users and membership. There are likely old posts somewhere on the internet about it. Otherwise I am pretty sure it was in the old Access Developers Handbook published by Sybex and written by Getz and Litwin (Litwen?)