show all tables

[Guest]

Is there a way to list all the table names, and fields if possible, in a query?

Thanks in advance,

Wei

 

[Allen Browne]

You can get a list of the tables by looping through the TableDefs
Collection. That approach also gives you the Fields collection, along with
the Properties of each field.

Example of listing the fields in a TableDef:
http://members.iinet.net.au/~allenbrowne/func-06.html