Get List of Table Fields
This demo shows how to retrieve a list of all table fields from an Access database file using a DAO object. The code loops through the TableDefs collection and skips all system and temp table and then collects some basic information about all the fields in each table. The information retrieved is stored in a temporary table for viewing (see image below).
An option to export the retrieved database information into Excel is provided since the temporary table is deleted during startup.
This demo was created using Access 2010 and tested using Access 2010, 2013, and 2016.
Please report all bugs to theDBguy@gmail.com.