Search notes:

MS Access: System Objects

MSysAccessStorage Records are added to this table when objects that contain code are created and the project is then compiled.
MSysACEs ACE = Access Control Entry
MSysNameMap
MSysNavPaneGroups Child table of MSysNavPaneGroupCategories
MSysNavPaneGroupToObjects Child table of MSysNavPaneGroups
MSysObjects Information about almost everything.
MSysQueries Information about queries (views): columns, where conditions
MSysResources
MSysRelationships Information on foreign key/primary key constraints.
MSysSchemaProb This table is present only when an error has occurred in updating the design of a replica

Some queries

MSysAccessStorage

select
   str.name,
   par.name     as parentName,
   ppr.name     as grandParentName,
   str.Id,
   str.Type,
   str.ParentId,
   str.DateCreate,
   str.DateUpdate,
   str.Lv
from (
   MSysAccessStorage str                            left join
   MSysAccessStorage par on str.ParentId = par.Id ) left join
   MSysAccessStorage ppr on par.ParentId = ppr.Id
Github repository about-Access, path: /system-objects/MSysAccessStorage.sql

MSysACEs

select
   obj.name, -- Same object can appear multiple times in result.
   ACM,
   FInheritable,
   SID
from
   MSysACEs     ace                            left join
   MSysObjects  obj on ace.ObjectId = obj.Id
Github repository about-Access, path: /system-objects/MSysACEs.sql

MSysNameMap

select
   map.id,
   map.name,
   map.nameMap,
   map.type     as mapType,
   par.Name     as parentName,
   map.guid
-- obj.*
from (
   MSysNameMap map                              left join
   MsysObjects obj on map.name     = obj.name ) left join
   MsysObjects par on obj.parentId = par.id
Github repository about-Access, path: /system-objects/MSysNameMap.sql

MSysNavPaneGroupToObjects

select
   pgo.Name                   as pgr_ObjectName,
   pgr.Flags                  as pgr_Flags,
   pgr.Icon,
   pgr.Name                   as pgr_Name,
   pgr.Position               as pgr_Position,
   cat.Filter,
   cat.Flags                  as cat_Flags,
-- cat.Id                     as cat_Id,
   cat.Name                   as cat_Name,
   cat.Position               as cat_Position,
-- cat.SelectedObjectId,
   obs.Name                   as SelectedObjectName,
   cat.Type                   as cat_Type,
   grp.Flags,
   grp.GroupCategoryId,
   grp.Id,
   grp.Name,
   grp.[Object Type Group],
   grp.ObjectId,
   grp.Position
from (((
   MSysNavPaneGroupToObjects  pgr                                    left join
   MSysNavPaneGroups          grp on pgr.GroupId          = grp.Id ) left join
   MSysNavPaneGroupCategories cat on grp.GroupCategoryId  = cat.Id ) left join
   MSysObjects                pgo on pgr.ObjectId         = pgo.Id ) left join
   MSysObjects                obs on cat.SelectedObjectId = obs.Id
order by
   grp.Id,
   pgr.Id
Github repository about-Access, path: /system-objects/MSysNavPaneGroupToObjects.sql

MSysQueries

select
   qry.Attribute,
   qry.Expression,
   qry.Flag,
   qry.LvExtra,
   qob.Name         as ObjectName,
   qry.Name1        as columnName, -- ?
   qry.Name2        as alias
from
   MSysQueries qry  left join
   MSysObjects qob on qry.ObjectId = qob.Id
order by
   qob.Name
Github repository about-Access, path: /system-objects/MSysQueries.sql

MSysResources

select
   data,       -- Paperclip (📎) symbol in output
   Extension,
   id,
   Name,
   Type
from
   MSysResources
Github repository about-Access, path: /system-objects/MSysResources.sql

Index