Forum Discussion
Bible_Tech
Apr 01, 2022Copper Contributor
Extra Tables?
I have recently experienced every time I create a new database in Access I see 5 new tables that are supposed to be hidden, I can open them, but I cannot delete them. Is this something new in Access ...
Bible_Tech
Apr 01, 2022Copper Contributor
Wow thank you for your reply, George! How shall I deliver it or copy and paste or screen shot?
George_Hepworth
Apr 01, 2022Silver Contributor
A screen shot will do. If I'm right (and there's always the chance I'm not) you are seeing the system tables which are in every accdb. They start out MSysxxxxx. However, I always prefer to work from concrete information when possible.
- isladogsApr 01, 2022MVP
- Bible_TechApr 04, 2022Copper ContributorYes that is what I am seeing. OK then , I have only recently seen these pop up. So you would think the default would be hidden from view so as not to distract the novice (me) from asking such questions. You cleared it up for me Thanks!
- isladogsApr 04, 2022MVPThe default is indeed for the system tables to be hidden BUT it is an application-wide setting.
In other words, if you set hidden or system tables visible in one Access database, that setting will apply to all other databases. Hide them in one database & they remain hidden in all other databases
- arnel_gpApr 03, 2022Iron Contributortables with names starting on Msys are system tables.
access create them if necessary.- George_HepworthApr 03, 2022Silver ContributorYes, that's what Colin and I are suggesting, pending confirmation from the OP, of course, that the tables in question are, in fact, this type of table.
- George_HepworthApr 01, 2022Silver ContributorThat's what my guess is too.