Purpose of System Tables

[CJ_London]

@John - So you are heading back as well? We were talking about where could we go for a winter weekend break only the other day - and thought of you guys. Haven't got around to doing anything about it yet....

@colin - work pressure is down a notch at the moment, so I'll give it a go

 

[NauticalGent]

CJ,

The plan is for me to start looking and go back once I find another job. My tenure here in Italy doesn’t expire until 2021, but once Missy landed a job in the chosen field she didn’t want to let the opportunity slip by. Couple that with newest addition to our family (Chloe) and the writing was in the wall.

 

[isladogs]

Good luck with that NG

Now ... getting back to the topic again ....I've finally managed to view all the very deep hidden system tables that I've mentioned several times in this thread.

I had a breakthrough due to a passing comment in an email from CJ_London with his solution for Security Challenge #1.

I've updated my website with more details of what these contain.
For anyone who cares, see http://www.mendipdatasystems.co.uk/purpose-of-system-tables/4594446646

TBH the outcome was all a bit of a letdown in the end as they do not seem to contain anything particularly crucial to ensuring an ACCDB file runs properly

 

[isladogs]

Pat
As you already know there are gaps of 16 between all the flags values in the list
Hiding any object fills the 'gap' by adding 8 to the 'default' MSysObjects flags value for that object.
So a hidden local table has flags 0+8=8 as does a hidden select query.
Hidden crosstab 16+8=24 etc

EDIT
Forgot to say that I made a create table data definition query to recheck the flags value. Definitely 96 or 104 if hidden.

Also I've no idea where those numbers come from in the latter part of your last post e.g. "3 for hidden selects"