You got me curious about the contents of MsysAccessObjects since Access doesn't let you see what's really in it. ADO.NET, however, has a GetOleDbSchemaTable method of the Connection object that does. I found a C# class that implements it, and this is what the output looked like when I connected the console app to a blank Access database (i.e., contains only system tables). The class is available at:
Just a bunch of database metadata about table and column properties:
Listing Table Metadata Information ...
Listing Tables ...
Listing Column Metadata Information ...
Listing Columns (TableName : ColumnName format)...
MSysAccessObjects : Data
MSysAccessObjects : ID
Press any key to continue
So it turns out, as one would expect, that MSysAccessObjects is the Access counterpart to the SQL Server 'Master' database. Difference is that in SQL Server, you can use these column values to query for schema information as in:
T.TABLE_NAME AS [A_Table],
C.COLUMN_NAME AS [B_Column],
C.IS_NULLABLE AS [C_NULLS],
C.DATA_TYPE AS [D_Type],
C.COLUMN_DEFAULT AS [E_DEFAULT]
INFORMATION_SCHEMA.Tables T JOIN INFORMATION_SCHEMA.Columns C
ON T.TABLE_NAME = C.TABLE_NAME
T.TABLE_NAME = 'Customers'
If I run this query against the SQL Server version of Northwind, I get the following output (sorry if this doesn't format right):
A_Table B_Column C_NULLS D_Type E_DEFAULT
Cutomers CustomerID No nchar NULL
Cutomers CompanyName No nvarchar NULL
Cutomers ContactName Yes nvarchar NULL
Cutomers ContactTitle Yes nvarchar NULL
Cutomers Address Yes nvarchar NULL
Cutomers City Yes nvarchar NULL
Cutomers Region Yes nvarchar NULL
Cutomers PostalCode Yes nvarchar NULL
Cutomers Country Yes nvarchar NULL
Cutomers Phone Yes nvarchar NULL
Cutomers Fax Yes nvarchar NULL
I don't think there is anyway to do this in Access.