Information on Access 97 Default System Tables

[llyal]

Information on Access 97 Default System Tables

When a new Access97 is created, 6 system tables are created;

MSysACEs
MSysModules
MSysModules2
MSysObjects
MSysQueries
MSysRelationships

What is each of the tables used for? What information is stored in each table?

Thank you!
Llyal

 

[MHM]

1st: be very careful! Normally system tables are hidden, which might be reasonable..

2nd: all data contained in these tables is made accessible in certain functions. Why not using them?

3rd: which kind of data are you searching for?

 

[llyal]

The reason i need "some" of this information is because i am making a database documenting application and need to be able to search through database objects for information; however, i would like to know the "full deal" on all these tables for future reference; the Microsoft website has been little help so far;

 

[Pat Hartman]

Microsoft does not document these tables because they do not intend for us to use them. They do not promise to maintain compatiblity between versions (and in fact they haven't) so basing a documentation tool on them could make the tool non-functional in a future version. WE are supposed to use the collections to obtain system information. There are samples in help of subroutines that extract information from various collections.