How can I obtain the groups that the current user belongs to without hard-coding an Admins ID and password in the code?
Microsoft Access 2.0: There is a way to do this; however, Microsoft does not support it. It will allow all users to view all groups and users membership. You do not need to use this technique in Microsoft Access 95 or later because you can now view group and user membership without being a member of the Admins group. Note Make sure you have made a backup copy of your workgroup information file (System.mda) before starting this process. If something goes terribly wrong, you stand a chance of locking yourself out of your application. The method relies on granting permissions to the Users group for two tables that reside in the workgroup file (which store user and group information): MSysAccounts MSysGroups You typically get an error if you try to read the information in these tables and you are not a member of Admins, because these tables are set up with no permissions for any other users or groups. Because the workgroup information file is just a Microsoft Access database, you can open
