Un-wanted Tables in New Database

[johngun1]

I hope someone can help me.

I have recently noticed that when I select to create a new d/b it is immediately populated with the following tables.

MSysACEs
MSysModules
MSysModules2
MSysObjects
MSysQueries
MSysRelationships

I am not aware of having changed any settings but this seems to have started suddenly for no apparant reason.

Cheers

johngun1

 

[stephen81]

These tables are normally hidden, but do exist in all your ms access databases. They are system tables.
Take a look at Tools -> Options then 'View' tab. Take the tick out of System Objects.

 

[johngun1]

Done in One

Hi stephen81,

Thanks for the quick response, you were spot on.

Much appreciated

Cheers

johngun1

 

[stephen81]

No problem.

 

[ghudson]

You can query the system tables for valuble information from within your database but you should never attempt to alter the data in a system table for you would risk corrupting your db.