Difference between revisions of "Microsoft Access System Tables"

Latest revision as of 23:52, 18 June 2012

Microsoft Access: MSysObjects Type
TypeId	Type
1	Table
2	MSysDb
3	Container: DataAccessPages, Forms, Modules, Reports, Scripts, SysRel, Tables, Databases, Relationships
4	Linked Table (ODBC)
5	Query
6	Linked Table (Jet)
8	Related Table
-32768	Form
-32766	Macro
-32764	Report
-32761	Module
-32758	User
-32756	Page
-32757	AccessLayout, SummaryInfo, UserDefined,

@@ Line 3: / Line 3: @@
 == MSysObjects ==
-{| class="wikitable"
+{| class="wikitable sortable" width="400"
 |+ align="bottom" | Microsoft Access: MSysObjects Type
-! style="text-align:right;" | TypeId !! Type
+! align="right" | TypeId !! | Type
 |-
-| 1 || Table
+| align="right" | 1 || Table
 |-
-| 2 || MSysDb?
+| align="right" | ''2'' || ''MSysDb''
 |-
-| 3 || Container
+| align="right" | ''3'' || ''Container: DataAccessPages, Forms, Modules, Reports, Scripts, SysRel, Tables, Databases, Relationships''
-* DataAccessPages
-* Forms
-* Modules
-* Reports
-* Scripts
-* SysRel
-* Tables
-* Databases
-* Relationships
 |-
-| 5 || Query
+| align="right" | 4 || Linked Table (ODBC)
 |-
-| 6 || Linked Table
+| align="right" | 5 || Query
 |-
-| 8 || Related Table
+| align="right" | 6 || Linked Table (Jet)
 |-
-| -32768 || Form
+| align="right" | 8 || Related Table
 |-
-| -32766 || Macro
+| align="right" | -32768 || Form
 |-
-| -32764 || Report
+| align="right" | -32766 || Macro
 |-
-| -32761 || Module
+| align="right" | -32764 || Report
 |-
-| -32758 || User
+| align="right" | -32761 || Module
 |-
-| -32756 || Page
+| align="right" | ''-32758'' || ''User''
 |-
-| -32757 ||
+| align="right" | ''-32756'' || ''Page''
-* AccessLayout
+|-
-* SummaryInfo
+| align="right" | ''-32757'' || ''AccessLayout, SummaryInfo, UserDefined, ''
-* UserDefined
 |}