Introduction of System Objects in Microsoft Access Database

In a MDB database, there are several system tables containing vital information about the database. These system tables are called system objects. They are maintained by Microsoft Access itself and are hidden to normal users by default. However, you can show them by the following steps:

  1. Select “Tools | Options” from the main menu.
  2. In the “View” tab, enable the “System Objects” option.
  3. Click “OK” to save the changes.

After that, you will see the system tables display with a slightly dimmed icon.

The names of all system tables will start with a”MSys” prefix. By default, Access will create the following system tables when creating a new MDB file:

  • MSysAccessObjects
  • MSysACEs
  • MSysObjects
  • MSysQueries
  • MSysRelationships

Sometimes Access will also create the system table ‘MSysAccessXML’.