MSysColumns ??? 1

[AbeMeister]

My SQL book says that Microsoft Access has the following System Catalogs:

MSysColumns, MSysIndexes, MSysMacros, MSysObjects, MSysQueries, and MSysRelationships.

I have found in my database:

MSysAccessObjects, MSysACEs, MSysObjects, MSysQueries, and MSysRelationships.

I would like to know where the other ones are!!

Microsoft states that they are supposed to exist.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q114991

"MORE INFORMATION - A system table is a table that contains information about the structure of a database. A Microsoft Access database has six default system tables; MSYSACES, MSYSCOLUMNS, MSYSINDEXES, MSYSOBJECTS, MSYSQUERIES, and MSYSMACROS. When you use a Microsoft Access database in Microsoft Query, and you select the System Tables check box in the Table Options dialog box, each of these tables appears in the Add Tables dialog box. However, when you create a new data source, and you use the Access Data ODBC driver, the MSYSMACROS system table is not added when you display the system tables for this data source."

All I really need is to be able to query MSysColumns Table. :-(

 

[tlbroadbent]

By default these tables are hidden. Open the Options on the Tools menu. Select Show System Objects. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[AbeMeister]

broadbent -

I realize that the tables are hidden. I unhid them, and MSysColumns is still not there.

 

[MichaelRed]

The ssytem tables changed from Ms. A '97 and Ms. A -2K. AFAIR, the list you qoute/cite is from ver '97 documentation, while the list you 'found' is nore like unto ver 2K (and further).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over