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;