database structure query

[abhinav]

how would i programmatically determine the strucure of an Access database.
say i wanted a list of all tables in the database that start with "blah".

 

[Allen Browne]

The code in this link illustrates how to loop through the Fields of the
TableDef:
http://allenbrowne.com/func-06.html

You can also loop through the TableDefs as well.