The Columns of the MsysObjects

[Derek via AccessMonster.com]

Hi, I would like to know what are the meaning and the use of each column of
the MsysObjects

1. Connect
2. Database
3. DataCreate
4. DateUpdate
5. Flags
6. ForeignName
7. Id
8. Lv
9. LvExtra
10. LvModule
11. LvProp
12. Name
13. Owner
14. ParentId
15. RmtInfoLong
16. RmtInfoShort
17. Type

Can anyone help me?

 

[Tim Ferguson]

Hi, I would like to know what are the meaning and the use of each
column of the MsysObjects

It's officially undocumented -- this means that although it's possible to
work out the meanings of the columns (and this is not hard and has been
done -- have you tried Googling?), there is absolutely no obligation on
Microsoft to maintain them in future versions of Access. There is therefore
not much point in hacking the system tables if you cannot tell that your
application will fail in Access version n+1.

All the functionality is available via normal DAO or ADOX methods anyway,
except for some properties that only have relevance to the GUI (such as
positions in the relationships window etc).

Hope that helps


Tim F

 

[Derek L via AccessMonster.com]

Thank you very much

Actually, I would like to make an add-in to Access 2003
Therefore, I am trying two approaches.
The first one is that I am trying to understand all the meaning, use and
relationships of the 5 tables,
MsysObjects, MsysAccessObjects, MsysQuerys, MsysRelationships, MsysACES
The second approach is to use the DAO, but I am trying to learn how to use
DAO too.