Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Linking to a Workgroup Information File

Linking to a Workgroup Information File

Linking to a Workgroup Information File


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:
  • Select a user from a list
  • Select a security group from the group list and then assign it to the chosen user.
The external link procedure in Access will not link to an .mdw file. So, I am hoping for a programming solution.

RE: Linking to a Workgroup Information File

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?)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close