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
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)
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