Mendip Data Systems

Database applications for businesses and schools


Code Samples for Businesses, Schools & Personal Use

Version 2.2  Updated 26/10/2020              


This item allows you to view all objects in a database.

The objects list 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 direct from the form.



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 the following 3 items to use this with your own database applications

   Form    - frmDatabaseObjects

   Report  - rptDatabaseObjects

   Table    - tblSysObjectTypes


3. No additional VBA references are required for this item


4. It works in 32-bit or 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


View Database Objects


Click the image to view a larger version ...

Return to Code Samples Page DatabaseObjects