Print a list of tables in MS Access 2007

[zufie]

Help!

How do I print a list of tables in MS Access 2007.

First, I selected Tables-->View By "List", but when I tried to Print,
but one table always remains highlight! What results is that the
fields of the highlighted table show and not the list of tables.

Next, I tried Database Documenter and under Options I: Unchecked the
boxes under Include for Table, Selected 'Nothing" under Include for
Fields and Selected 'Nothing" under Include for Indexes.

This is what I got for each table:

W:\GROUPS\ALIS\Restore\ALAP.mdb Thursday, August 27, 2009
Table: AL/SH Advisory Board Basic Data Page: 1

It is a 74 page Word document.

I have to provide a separate list for tables, queries, reports, and
forms.

Any ideas?

Thank you!

John

 

[Jerry Whittle]

SELECT "Table" AS

,
MSysObjects.Name,
MSysObjects.Type
FROM MSysObjects
WHERE MSysObjects.Type =1
Or MSysObjects.Type=6
ORDER BY MSysObjects.Name;

1 is a normal table. 6 is a linked table.

 

[Jerry Whittle]

If you need a list of everything, try this:

SELECT IIf([MSysObjects].[Type]=1,'TABLE',
IIf([MSysObjects].[Type]=5,'QUERY',
IIf([MSysObjects].[Type]=-32768,'FORM',
IIf([MSysObjects].[Type]=-32764,'REPORT',
IIf([MSysObjects].[Type]=-32766,'MACRO',
IIf([MSysObjects].[Type]=-32761,'MODULE',
IIf([MSysObjects].[Type]=-32756,'PAGE',
IIf([MSysObjects].[Type]=8,'RELATIONSHIPS',
IIf([MSysObjects].[Type]=6,'TABLE LINKED','Unknown'))))))))) AS ObjectType,
MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~*"
And (MSysObjects.Name) Not Like "Msys*")
AND ((MSysObjects.Type) Not In (2,3)))
ORDER BY IIf([MSysObjects].[Type]=1,'TABLE',
IIf([MSysObjects].[Type]=5,'QUERY',
IIf([MSysObjects].[Type]=-32768,'FORM',
IIf([MSysObjects].[Type]=-32764,'REPORT',
IIf([MSysObjects].[Type]=-32766,'MACRO',
IIf([MSysObjects].[Type]=-32761,'MODULE',
IIf([MSysObjects].[Type]=-32756,'PAGE',
IIf([MSysObjects].[Type]=8,'RELATIONSHIPS',
IIf([MSysObjects].[Type]=6,'TABLE LINKED','Unknown'))))))))),
MSysObjects.Name;