Version 2.3             First Published 22 Mar 2017             Last Updated 20 Sept 2022

The example app attached provides code to view a list of all database objects.
It also allows you to view the metadata for each object: date created / date modified / object description

The list of database objects is obtained from the hidden system table MSysObjects.
It is updated automatically as objects are added to or removed from the database.



Depending on the object type, you can choose to open the object in design view or run it directly from the form.

The object metadata is the same as that shown in the navigation pane when using Details view



NOTE:
1.   So you can see this in action, I have included a number of dummy objects in the attached application e.g. Table1, Query1, Query 2 etc

2.   Copy ALL the following items to use this with your own database apps
            Forms      - frmDatabaseObjects & frmObjMetadata
            Report     - rptDatabaseObjects
            Tables     - tblSysObjectTypes, tblObjMetadata
            Module    - modObjMetadata

3.   No additional VBA references are required for this item

4.   The app works in both 32-bit and 64-bit Access

Click to download :    View Database Objects      Approx 0.8 MB (zipped)


VERSION HISTORY:
v1.0   22/03/2017 - Initial release
v2.2   26/10/2020 - Bug fixes & other improvements following feedback by Adam L. Many thanks
v2.3   20/09/2022 - Added Relationships to list of database objects. Added object metadata



Colin Riddington           Mendip Data Systems                 Last Updated 20 Sept 2022

Return to Example Databases Page

Return to Top