msys Tables

[Joe Hecht via AccessMonster.com]

I understand they are under the hood things for Access. What do they do and
when would I use them in development.

 

[Arvin Meyer]

They are the system tables that keep track of the objects, relationships,
etc. They are rarely used by developers except to extract something like:

SELECT DISTINCTROW MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1 Or
(MSysObjects.Type)=6));

Which will get all the table and linked table names.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

I understand they are under the hood things for Access. What do they do and
when would I use them in development.

Microsoft hasn't chosen to reveal the details of their structure; some
things can be figured out easily enough, but some of the fields are
BLOB's which (somehow) contain the details of the objects in your
database or other features thereof.

In practice, the tables are not editable and you probably wouldn't
want to edit them anyway. The DAO object model provides tools to
manage your database objects, and that's the preferred technique.

John W. Vinson[MVP]