Get/Retrieve Database Extended Properties
This demo is a complement to this blog showing how to get the summary info for an Access database file.
It shows how to retrieve all the extended properties of an Access database file using a DAO object. The code loops through the Container objects and examines the Document objects in each container to retrieve the database properties. 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.