Difference between revisions of "Microsoft Access System Tables"

From database24
Jump to navigation Jump to search
Line 3: Line 3:
 
== MSysObjects ==
 
== MSysObjects ==
  
{| class="wikitable"
+
{| class="wikitable" width="400"
 
|+ align="bottom" | Microsoft Access: MSysObjects Type
 
|+ 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 || ODBC Linked Table
 
|-
 
|-
| 6 || Linked Table
+
| align="right" | 5 || Query
 
|-
 
|-
| 8 || Related Table
+
| align="right" | 6 || Linked Table
 
|-
 
|-
| -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
 
 
|}
 
|}

Revision as of 22:14, 11 February 2012


MSysObjects

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