Re: Query to obtain Schema and other info about the DB tables

Thanks.
Exactly what I was looking for.



"Douglas J. Steele" wrote:

> The following query will give you the tables:
> 
> SELECT [Name]
> FROM MSysObjects
> WHERE Name Not Like "MSys*"
> AND [Type] In (1,4,6)
> ORDER BY [Name]
> 
> (type 1 means tables in the same database, type 4 means tables linked
using 
> ODBC, type 6 means other linked tables).
> 
> The following query will give you the queries:
> 
> SELECT [Name]
> FROM MSysObjects
> WHERE [Type] =5
> ORDER BY [Name]
> 
> To avoid reinventing the wheel, you might check what Jeff Conrad has at 
> http://www.accessmvp.com/JConrad/accessjunkie/doctable.html
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
> 
> 
> "JohnS" <JohnS@[EMAIL PROTECTED]
> wrote in message 
> news:D929FF51-F5D4-400E-A7D3-F64A8B0D7C10@[EMAIL PROTECTED]
> > Is there a way to query Access (from within Access) to get a list of
the
> > tables and queries in the DB?
> >
> > I am trying to do***ent a DB and would like to list out the table
names 
> > and
> > get counts of tables without counting them by hand and retyping the
names 
> > by
> > hand.
> >
> > TIA
> >
> > 
> 
> 
>