System1.mdw

Queries

It seems, that System1.mdw contains four queries.

MSysGroupList

SELECT MSysAccounts.Name
FROM MSysAccounts
WHERE (((MSysAccounts.FGroup)<>0))
ORDER BY MSysAccounts.Name;

MSysGroupMembers

PARAMETERS GroupName Text ( 255 );

SELECT DISTINCT MSysAccounts_1.Name
FROM (MSysAccounts INNER JOIN MSysGroups ON MSysAccounts.SID = MSysGroups.GroupSID) INNER JOIN MSysAccounts AS MSysAccounts_1 ON MSysGroups.UserSID = MSysAccounts_1.SID
WHERE (((MSysAccounts.name)=[GroupName]) AND ((MSysAccounts.FGroup)<>0) AND ((MSysAccounts_1.FGroup)=False));

MSysUserList

SELECT MSysAccounts.Name
FROM MSysAccounts
WHERE MSysAccounts.FGroup = 0
ORDER BY MSysAccounts.Name;

MSysUserMemberships

PARAMETERS UserName Text ( 255 );

SELECT DISTINCT MSysAccounts_1.Name
FROM (MSysAccounts INNER JOIN MSysGroups ON MSysAccounts.SID = MSysGroups.UserSID) INNER JOIN MSysAccounts AS MSysAccounts_1 ON MSysGroups.GroupSID = MSysAccounts_1.SID
WHERE (((MSysAccounts.name)=[UserName]) AND ((MSysAccounts.FGroup)=False) AND ((MSysAccounts_1.FGroup)<>0));

Path to System1.mdw

The path to System1.mdw (which usually seems to be located in %APPDATA%\Microsoft\Access) can also be found in VBA like so:

debug.print application.dbEngine.systemDB

This path is also stored in the registry in the value of SystemDB under the registry key HKEY_CURRENT_USER\Software\Microsoft\Office\X.Y\Access\Access Connectivity Engine\Engines.

Alternatively, it can also be queried with

debug.print sysCmd(acSysCmdGetWorkgroupFile)