Just a clarification please

[gear]

When I made my Database, my Access Objects window displayed only the tables I created apart from the default Create table in design view, Create table using wizard and Create table by entering data. After finalising the database, I transferrred it to another PC and made some changes. The changed database was copied in pendrive and put in my harddrive. When I opened the DB, I find the following additional things in the Objects window :

MySysAccessObjects
MySysAccessXML
MySysACEs
MySysObjects
MySysQueriesMySysRelationships

How did this happen? It cannot be deleted. What is this? Can anyone explain?
Thanks in advance.

 

[RoyVidar]

They are system tables.

Tools | Options - View tab, uncheck Hidden and System tables.

Sometimes, for some reasons, it seems they want to stay there. Right click, properties, check Hidden.

If you succeed in deleting any of them, I think you have problems

 

[The_Doc_Man]

Gear, these are the overhead tables Access uses to store the metadata about your database.

MSysObjects defines the tables, forms, reports, macros, and modules. The tabledef and documents collections are based from entries in this table.

MSysQueries - same as ...Objects but for pre-defined queries.

MSysRelationship - stores what you do when you open the Relationship window and do something permanent.

MSysACEs defines the object security. If you impose security in your DB, it is recorded as an Access Control Entry (ACE) - hence the name.

Having not used the others very much, all I can do is suggest that the XML table has to do with permanent things you do with XML - like ADP stuff? The AccessObjects is also new, probably related to something permanent you create with one or more program actions.

DO NOT DELETE THESE TABLES. EVER. (and this time, I'm not qualifying it with "hardly ever.")

 

[KenHigg]

FYI - I'm not sure you can delete these. I know you can't change the data in some of them

 

[gear]

Thanks for the reply friends. Yes it cannot be deleted. As RoyVidar suggested, I could make it disappear by unchecking from Tools - Options - View - System Objects. Thanks to Doc Man for the clear info on these.