/Access-Database-Property-Editor-Addin

A Microsoft Access Add-In tool to help view and edit MS Access database level properties.

MIT LicenseMIT

The Microsoft Access Database Property Editor Add-In

This 100% Free Microsoft Access Add-In tool was designed to help view and edit MS Access database level properties for any database you have open in MS Access. The database level properties are the DAO properties found in the Application.CurrentDB.Properties collection. These properties are generally the database level settings used within the Microsoft Access client for your specific Access database application. Changing these properties manually CAN BE DANGEROUS and difficult to do, and this tool is an attempt to make it safer to edit these properties, as well as make it super simple to quickly view all the database properties for any given Access database application.

Where to Download:

Download the FREE Microsoft Access Database Property Editor Add-In (.accda file) here: Latest ACCDA Download

Or download the latest Stable Release package here: Latest Full Release Package

How to Install:

To just install the latest version of this Access Add-In without messing with any of the source code, complete the following steps:

  1. Download the latest ACCDA file from HERE.
  2. Open any database in Microsoft Access and go to the "Database Tools" ribbon menu.
  3. On the "Database Tools" ribbon, click the "Add-Ins" option drop down, and choose the "Add-In Manager" option. This will open the Access "Add-In Manager" form.
  4. On the "Add-In Manager" form, click the "Add New..." option. The Access "Open" file dialog will be opened.
  5. On the "Open" file dialog, navigate to the ACCDA file you downloaded and click the "Open" button.

You will be taken back to the "Add-In Manager" form and the Add-In should now show as installed.

How to Use this Tool:

To use this tool once it has been installed:

  1. Open any Access database in Microsoft Access.
  2. On the "Database Tools" ribbon, click the "Add-Ins" option drop down, and choose the "Db Property Editor" option. The Database Property Editor "Start" form will open.
  3. Click on the "View Database Properties" button on the "Start" form. A form showing a list of all the database level properties for the current database will opened.

Screenshots of the MS Access Database Property Editor Tool:

The following are some screenshots of the primary forms used within the MS Access Database Property Editor tool:

  1. Screenshot of the Access Database Property Editor 'Start' form:

Screenshot of the Access Database Property Editor 'Start' form

  1. Screenshot of the Access Database Property Editor 'Property List' form:

Screenshot of the Access Database Property Editor 'Property List' form

  1. Screenshot of the Access Database Property Editor 'Property Details' form:

Screenshot of the Access Database Property Editor 'Property Details' form

Project Contributors:

A GREAT BIG THANKS to the following contributors to this project:

  1. George Hepworth - For hosting the Access Pacific Users Group and inspiring this tool.

  2. The Access Pacific Users Group - For their community help and support of Access and their contributions to testing this tool.

  3. Geoffrey Griffith - For his work to create this 100% Free Database Property Editor tool for Microsoft Access.

Other Free Microsoft Access Tools:

Some other projects I've created in MS Access that I've also made available 100% FREE:

  1. Access Add-In Helper

  2. Remove VBA Line Numbers Add-In

  3. Win32 API Declarations for VBA