MSys tables new to me

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been using MS Access for some time now. I converted over to 2003 version
about 8mos to 1 year ago.

Today, I create a new database and I see MSys tables that I've never seen
before. When did these start showing up?
What are they used for?
Do I need to have them in my tables list?
 
Today, I create a new database and I see MSys tables that I've never seen
before. When did these start showing up?
Click to expand...

In September of 1991, when Access 1.0 was released.
What are they used for?
Click to expand...

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?
Click to expand...

<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
 
No, you don't need them in your list but they are vital to
the working of Access. These tables are normally hidden
from sight. I'm not sure where it is in A2003 but in A2000
it's in Tools|Options then on the View tab clear the System
Objects check box.

--
Nick Coe (UK)
Available - Will work for money :-)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Kevin typed:
 
Thanks everyone.

That did the trick. I jut wasnt used to seeing those tables. I typically
have many tables in my databases and I really didnt need any others to
confuse the issue.

Again, thanks for the help
 
Back
Top