query to list all tables in database?? 1

[numbered]

Is there an sql query to list all tables in an ms access database?

 

[LittleSmudge]

I've not seen it done in a SQL query - but you can certainly do it in VBCode

A table is an object in the tables collection of the Database ( Or Connnection ) object
( Depending on whether you're using DAO or ADO )

So simply enumerate through the collection and print to a txtControl on a form - or whereever you need it to go.



'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[numbered]

Thanks LittleSmudge but, I found the answer to my own question.

SELECT msysobjects.name
FROM MSysObjects

 

[LittleSmudge]

Well done numbered

So why didn't I think of that one !


Have a (humbly given) star from me for that.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[numbered]

Thanks for the star...(blush)

 

[essnrv]

Look at this thread
thread702-383980 Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

 

[MichaelRed]

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1))
WITH OWNERACCESS OPTION;
[/code

And ADD the Conditionals!  Your attempt lists ALL objects, nit just the tables, AND, it includes the system tables which are not generally considered to be part of the db.

 MichaelRed
m.red@att.net

Searching for employment in all the wrong places