Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

How to stop the creation of the MSys tables:0

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
               MSysACEs
               MSysObjects
               MSysQueries
               MSysRelationships

How and why are these being created?

Thank you,

Peter Lannigan
0
plannigan1
Asked:
plannigan1
  • 2
  • 2
1 Solution
 
Arthur_WoodCommented:
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.

AW
0
 
plannigan1Author Commented:
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,

Peter
0
 
Arthur_WoodCommented:
yes, on the Tools/Options dialog...simply UNCHECK both System and Hidden.

AW
0
 
plannigan1Author Commented:
Thank you.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now