Today, I create a new database and I see MSys tables that I've never seen
before. When did these start showing up?
In September of 1991, when Access 1.0 was released.
Internal house-keeping. For example, if you run a query like this:
SELECT Name FROM MSysObjects ORDER BY Name
You will see that Access stores in a table, a list of all objects in the
database.
You can also determine the local tables vs linked tables:
SELECT Name, Connect, ForeignName
FROM MSysObjects
ORDER BY Type, Name
Once you create an Import / Export specification, you can query
MSysIMEXSpecs and MSysIMEXColumns, or use them on a form to give users a
better way of manipulating them since the Import / Export Wizard is SOOO
retarded.
Do I need to have them in my tables list?
<h1> YES!! </h1> Without these tables, your Access database will be totally
hosed beyond repair. If you feel nervous about seeing them, you can make
them invisible like this:
1. Tools -> Options -> [View] Tab
2. Uncheck Hidden Objects
3. Uncheck System Objects
4. Click OK
--
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane
