Friday, November 25, 2005

New v2.0 of Object Dependency Browser Add-In for Microsoft© Access

Use Object Dependency Browser *(OBD) to dynamically explore all objects, object collections, and dependencies of your Access database. Microsoft introduced a native object dependency viewer in Access2003, where objects can be viewed in separate treeviews:
  • objects that depend on me, and
  • objects that I depend on.

ODB goes much further:

  • Supports Access 97, Access 2000, Access 2002, and Access2003
  • The two dependency views are integrated in the one treeview. For example, in the above screenshot, ODB displays not only the fields collection for the Customers table, but linked tables and joins, and all other objects in the database that depend on the Customers table.
  • Clicking on a join field will show the related to table/field and the type of join.
  • Full dependency details are also displayed in the adjacent properties pane
  • Each object can be fully documented in a formatted Access report by clicking the Document button.
  • Copy of all object details from the properties pane to the Windows clipboard by clicking the Copy to Clipboard button.
  • Open database objects in design view with a click of the Design button.

ODB v2.0 offers these new additional features:

  • Explicitly documents Union query source tables/queries
  • Documents for Queries: depend on me queries
  • Documents Data Access Pages (Access 2000 and later)
  • Documents Custom Command Bars
  • Documents for Forms: custom Menubars, Toolbars, and Shortcut Menus

This update completes the recent upgrade cycle for three Access add-ins, which offer exceptional functionality and ease of use:

Ezy Documenter Premium Edition Automatically documents and prints in fully formatted Access reports all the objects in your Access database: tables and fields, table relations, query definitions, forms and record sources, reports and record sources, code modules, macros, data access pages, references, custom command bars, and database properties. The Premium Edition allows user customization of each Ezy Documenter Database Report. Reports can be exported in varied formats.

123 Error Handler Wizard Instantly add error-handling to your databases: 1. The Wizard reviews your database and identifies all procedures without error-handling, and reports the On Error... statement for all other procedures. 2. You select which procedures to add error-handling. 3. The Wizard adds error-handling to the selected procedures in one automated operation.

Object Dependency Browser The easy way to explore all objects, objet collections, and dependencies of your Access database. Microsoft introduced a native object dependency viewer in Access2003. ODB goes much further. ODB supports Access 97, Access 2000, Access 2002, and Access2003, and all dependency views are integrated into the one treeview.