How to stop the creation of the MSys tables:0

Posted on 2003-02-24
Medium Priority
Last Modified: 2006-11-17
I am just learning how to use MS Access and every time I create a new database the following 4 tables are created automatically: MSysAccessStorage

How and why are these being created?

Thank you,

Peter Lannigan
Question by:plannigan1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 44

Accepted Solution

Arthur_Wood earned 200 total points
ID: 8010470
sorry, bit those four tables are ABSOLUTELY required for Access to function properly.  They are known as SYSTEM tables, and hold records which describe the rest of your application.

For instance, MSysObjects holds data about ALL of the other 'object' (Tables, Forms, Queries, Reports, Modules. etc) that make up the contents of your database.

MSysRelationships holds the necessary information for Access to properly create and manage relationships between tables in your database.

In fact, there are a total of 6 System Tables that are created at one time or another.  They are the Access equivalent of the fundamental Operating System files that are held in WinNT/System and WinNT/System32, without which Windows would not function.

In genearl, you should not disturb the system files, though, once you become familiar with what is contained therein, you might find it useful, under some circumstances, to be able to list the names of ALL of the Tables that are present in the database.  But for now, simply rely on the fact that htese tables are all necessary for the proper functioning of Access.


Author Comment

ID: 8010705
Thank you for the insight Arthur. Is it possible to hide these tables from the users? I never saw them before and I do not know what I changed.

Thank you,

LVL 44

Expert Comment

ID: 8013911
yes, on the Tools/Options dialog...simply UNCHECK both System and Hidden.


Author Comment

ID: 8019739
Thank you.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question