Add-In and Wizard for Microsoft© Access 97-2016
NEW Version 3.0 for Access 2007-2016 adds the option of showing object dependencies for table, query, form, report and commandbar objects in all VBA modules, returning the module name, the line number, and the full line of text for each instance.
The easy way to 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:
The two dependency views are integrated in the one treeview: for example in the screenshot below, 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 versions 2.0 anmd 3.0 support Access 2007/2010/2013/2016 and offers these additional features:
Explicitly documents Union query source tables/queries
Documents for Queries: depend on me queries
Documents Data Access Pages (Access 2000/2002/2003)
Documents Custom Command Bars
Documents for Forms: custom Menubars, Toolbars, and Shortcut Menus
SPECIAL PACKAGE DEAL Buy ODB v3.0 and Ezy Documenter & save US$20
ODB Version 1: Only US$29.95 including entitlement to upgrade pricing (US$10) on v2.0: Secure payment with PayPal. Files download URL will be e-mailed.
ODB Version 1
ODB Version 2/3: Only US$39.95 including free upgrades to new versions:
ODB Version 2/3