Download Page

License

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

How to install

Use the inbuilt MS ACCESS Add-In Manager to install this tool.
Start it with (Database) Tools->Add-Ins->Add-In Manager.

How to use

Open the Access DB you want to analyze
Navigate in the menu to (Database) Tools->Add-Ins->Dependency Checker and the Startup Screen should pop up.


Download

Here the latest version for download: ACCESS Dependency Checker 2.0.1

If you encounter problems with the above version  and you have a 64-bit Office please try this version: ACCESS Dependency Checker 2.0.1 64bit

If you have issues with the latest changes, you might want to try the older version (1.0.2).

Changelog

2.0.1 (04-Jun-2017)

  • Fixed Run-Time Errors
    Fix: Avoids RTE for Empty Cells on Forms (new Access feature)

2.0.0 (03-Jan-2016)

  • 64-bit ready
    Change: Switched to all-VBA Treeview (thanks to Jan Karel Pieterse for creating it)
    Change: Switched to VBA progress bar (avoiding 32-bit ActiveX control)
    Change: Universal API calls working under 32 and 64 bit Office
  • Wide-screen mode
    Add: New option on startup screen for wide screen mode
    Add: Now all data on one form (if new option has been selected)
  • Covering more dependencies
    Add: Now covering custom forms
    Add: Now supporting new macro actions: SetLocalVar, RefreshRecord, RunDataMacro, ImportExportData, ImportExportText, ImportExportSpreadsheet, ImportSharePointList, SetParameter
    Add: Now supporting new query type "Bulk Pass-Through"
    Add: Now supporting new table field type "Attachment"
    Add: Now finding objects as arguments in functions used in SQL (like DLookup() in Fieldslist of Query)
    Add: Now finding objects as arguments in functions used in CommandBarControls
    Add: Now finding object names in textbox control sources
  • Misc
    Fix: No RTE if using parameter in fieldlist of a query

1.0.2 (08-Mar-2014)

  • Fixed Run-Time Errors
    Fix: Now using the font of the VBA IDE on the details form (enumerating the system fonts created a RTE on some systems)
    Fix: Now handling objects with names containing special RegEx characters correctly
    Fix: No RTE/error anymore if macro has a backslash at end of a string
  • Misc
    Add: Now ignoring the new EmptyCell control (introduced with AC2010)
    Add: Added rudimentary support for navigation, webbrowser and attachment control
    Fix: Allow =FunctionName (with =) for RunCode Argument
    Fix: Fixed the "Refresh" of the analysis
    Fix: now finding query and table names in square brackets during brute force analysis
    Fix: solved problem with report footer if unusual or many sections are used
    Fix: now handling split macro lines correctly if the string contains escaped characters
    Fix: Fixing transfer of popup menu into clean DB

1.0.1 (24-Apr-2013)

  • Export into clean DB
    Add: Nodes flagged for export are now marked with a different back color
    Add: added copying of icons used in custom menus
    Add: added copying more properties of command bars
    Fix: avoid RTE if known property shall be created in new DB
    Fix: avoid RTE when copying shortcut menu
    Fix: avoid RTE when DB contains embedded macros
  • Misc
    Fix: Solved problems on very large (multi-monitor) screens
    Change: Improved bug reports for some cases
    Add: Added name of parent of embedded macros to displayed name
    Fix: Fixed a couple minor bugs

1.0.0 (30-Dec-2011)

  • Export into clean DB
    Add: Added command bars to the scope of this feature
    Add: Added startup options and DB properties
    Add: Include AutoKeys macro
  • Fixed Run-Time Errors
    Fix: avoided usage of Mid() in a query what caused RTEs in some configurations
    Fix: avoid RTE if data that shall be copied to Excel starts with = * + -
    Fix: avoid RTE if using picture embedded in object frame
    Fix: avoid RTEs if listbox context menu on main is called without an entry selected
  • Misc
    Add: Added linked commandbar names to content for forms and controls
    Fix: avoid false missings if a control name starts with a number
    Fix: now parsing procedures called by a macro with an argument correctly
    Fix: now handling escaped double quotes in macros correctly
    Fix: no missing source if SendObject, OutputTo etc. do not contain an object name'

1.0.0b (10-Apr-2011)

  • Export features
    Add: Added ability to export any portion of a treeview (as shown) to Excel
    Add: Feature to export objects and all their dependencies into a clean DB
    Add: Feature to export a list for all required objects for a given one (called dependency chain)
    Fix: avoid redundant entries in tADC_ObjectLinks for code links (found by real parsing _and_ brute force text search)
  • User Interface
    Add: Better bug report and more graceful behaviour when creating a DB object with a too long name
    Add: Allow user to continue if max number of expansions for "Expand below" has been exceeded
    Change: Unified message windows if user acknowledgement is required
    Add: Added option to hide unlinked children in treeview
    Add: remember treeview style and 'hide unlinked children' status
    Change: New flyout menu in treeview instead of two drop-downs
    Fix: avoid RTE when resizing forms on super large screens
  • Dependencies
    Add: added coverage for "ApplyFilter" macro action
    Add: now listing all table fields, not only linked ones
    Add: does now find nested VBA function calls in SQL
    Add: added coverage for embedded macros available since Access 2007
    Fix: now handling nested queries with alias like "SELECT * FROM (SELECT * FROM tTable) as t" correctly
    Fix: reduced false positives in code: reports, macros and commandbars followed by a space will not be found any longer
  • Misc
    Fix: added '^' (bitwise exclusive or) to valid tokens in an SQL string
    Fix: added missing line feeds in content of controls
    Fix: avoid RTE when started in A2010 without a loaded DB
    Fix: avoid RTE when trying to open an unaccessible table in design mode
    Fix: improved IsSQL() so that preceding spaces in handwritten SQL do not confuse the function
    Fix: changed a couple Integer to Long to allow for DBs with more than 2^15 objects or object links

0.9.10 (26-Sep-2010)

  • Fix: no RTE now when using embedded macros in Access 2007/2010
    Fix: no RTE now when trying to open a missing object in design view
  • Fix: no RTE now if trying to load a stored analysis that is incompatible (due to new version)
  • Fix: no RTE now if the "Switchboard Items" table is a linked table and not reachable
  • Add: added keyboard shortcut to add-in name

0.9.9 (25-Aug-2010)

  • Covered dependencies
    Add: now covering VBA calls to procedures in form/report module
    Add: now correctly linking custom toolbars for forms/reports
    Add: now finding all defined events for forms/reports/controls
    Fix: avoid false link to missing object with no name for an unbound subforms
    Fix: fixed issue with labled macro called from a command bar
    Fix: now handling sub-queries correctly that are obfuscated by Access when saved in design view
  • Export features
    Add: added ability to export all objects and their dependencies to Excel or into the Host DB
    Add: added custom menues to text export
    Add: added ability to export results of find, search and special searches (lower left listbox) to Excel
    Change: now opening an exported text-file in the editor to be consistent with behaviour for Excel export
  • GUI
    Change: structural nodes in treeview now colored blue to better distinguish from DB objects
    Change: combined "Top Items" and "Unused objects" into one view, removed "Bottom Items" view (more or less useless)
    Add: added "All CommandBars" and "All CB Controls" to predefined special searches
    Add: re-arranged checkboxes on startup screen to match Windows standard
    Fix: "Select All" on Startup Screen now includes the checkbox for command bars
    Fix: Set "Popup" property for pop-ups to "Yes" what improves the appearance in A2007+
  • Fixed Run-time errors
    Fix: fixed the Heisenbug that caused sporadic RTEs when loading the tree view
    Fix: no RTE now in case of illegal SQL that would confuse the indenter
    Fix: no RTE now, for an empty class module
    Fix: no RTE now, if a command bar contains a combobox control
    Fix: no RTE now, if a custom menu calls a function without trailing parenthesis
    Fix: no RTE now, if using an option group on a report

0.9.8 (18-Apr-2010)

  • Covered dependencies
    Add: no covering custom menus and their links to DB objects
    Add: completed support for ActiveX controls; now linking event procedures for custom controls (like treeviews) correctly to the control events
    Add: now covering form/report section events controls
    Add: now covering switchboards (with object names stored in a table called "Switchboard Items")
    Fix: now correctly reporting nested functions like function1(function2())
    Fix: now correctly linking event procedures if the control name contains "illegal" characters like spaces (procedure name has underbars then)
  • Run-time errors
    Fix: now no RTE anymore for constructed DELETE queries in VBA like "DELETE " & table & ".* FROM ..."
    Fix: no RTE now, if selecting "---------" in the tree view drop-down
    Fix: no RTE now for extra long SQL statement in code (255+ chars)
    Fix: an empty macro caused a RTE
  • Treeview
    Change: Now showing ALL controls on forms and reports as a DB object linked in the tree view
    Fix: Adjusted/corrected sorting of tree view child nodes
    Add: Automatical horizontal autoscroll of the treeview to show clicked node and icon
    Add: Added screen message if "Expand below" has been cancelled because the maximum expansions has been exceeded
    Fix: suppressed screen flickering and unintentional scrolling if double clicking in the tree view
    Change: changed default for double click in object window to "Set as Root" (was "Show Details") including tree view update; adapted history (for "Forward" and "Back" buttons) to correctly update treeview or not
  • Misc
    Fix: added code to remove cmbObjectList and cmbTVContextMenu commandbars from analysed DBs inadvertently create by using ADC 0.9.5/6/7
    Fix: Now handling long macro actions correctly (reverse truncation caused by SaveAsText function)
    Add: Add content for controls
    Fix: now also marking SQL concatenated with "+" instead of "&" as incomplete
    Fix: DBObjects Window: large contents did not scroll correctly to the top but to 2nd row

0.9.7 (12-Dec-2009)

  • Fix: "Store in DB" feature introduced with 0.9.6 did not work in some settings due to a race condition. Changed the technique to store data in the host DB to fix this.
  • Add: Include DB name now in error report

0.9.6 (29-Nov-2009)

  • Add: Allows now to store the analysis result in the database itself (in three hidden tables). This avoids the (sometimes lengthly) analysis run at every start of the add-in. The added tables can also be removed again (e.g. prior to a release)
  • Add: Now reporting functions called by custom menus that are defined in VBA
  • Fix: Avoid RTE if user inadvertently stops the Addin code when working in the VBA IDE
  • Fix: Avoid RTE for super large macros

0.9.5 (13-Nov-2009)

  • Tree Views
    Add: Unified Tree Views in Main and DB Object window, enhancing the functionality in the DB Object window (e.g. allow to click thru tree, seed TV with lists etc.)
    Add: Added Treeview options "All Types" (like in DB Object Window) and "Both" (Top-Down and Bottom-Up)
    Add/Change: allow to jump to detailed view with double click on tree view node
    Fix: avoid editing of node text
  • DB Object Window
    Add: Allow to reset resizer bar position with double click
    Add: Unlimited history list on DB Object form, allowing to navigate back and forth
    Change: changed buttons on Details form to icons (from text)
  • Debugging / Error Reporting
    Add: Improved error handling in AnalyzeDB() and subfunctions, added custom error messages
    Add: Added version build number, UI History and line number to Error Report
    Fix: Fixed problem during error reporting (unwanted shut-down of tool in some cases)
  • Run Time Errors
    Fix: Avoid RTE if user cancels the "Analysis in progress window"
    Fix: Analysis crashed in Access 2007 -> fixed SaveToTable() methods to be version safe
    Fix: Avoid RTE for incomplete SQL with unmatched open parethesis
  • Options
    Change: changed default for "Optimistic Parsing" to YES, should be safer to get too many than to little results especially as long as VBA parsing is not complete
    Change: VBA parsing now defaults to "YES", should be safe with "Optimistic Parsing" defaulting to yes
    Change: changed names for options so that default is always NO : Optimistic Parsing -> Strict Parsing and Indent SQL -> Show SQL as is
  • Dependencies and Object handling
    Fix: removed Standard Modules from list of top nodes
    Fix: better handling of 'name-less' missing objects
    Fix: Wrong link has been reported for field lookups in some cases
  • Misc
    Fix: Now opening parent object if clicking "open in design" on SQL statements, fixes for other types
    Fix: opening a subform in design mode (for analysis) closed the parent in normal view mode

0.9.3 (06-Jul-2009)

  • added reporting of custom VBA functions in queries and other SQL based objects
  • added "Debug Mode" option to easily disable error handling for bug hunting purposes
  • changed tree view from full-load-on-start-up to build-up-on-the-fly (faster, more flexible); removed now unneccessary options (thanks, Matt and TJ for reporting this)
  • rearranged controls on Main Window making more space for the list control
  • improved/fixed code parsing: avoid RTE if form modules contains Property Let/Get/Set; fixed detection of class usage in code (kudos to Gonzo for bug hunting support)
  • fixed problem when analysing subforms on forms/reports on non-English systems

0.9.2 (24-Feb-2009)

  • Addded option for 'optimistic parsing' to make 'Unused objects' list more useful. Searches code and events for object names. Works well if your database objects have unique names (like tblXXX, qryYYY); reports false links if not.
  • Improved Macro parsing (now showing text instead of code numbers in action details)
  • Some bug fixing

0.9.1 (02-Feb-2009)

  • Renamed tool (to avoid conflict with commercial product) and moved to dedicated domain.
  • Added coverage for Form Controls as conditions in Queries
  • Added option to de-select all object types in startup dialog

0.9.0 (30-Jan-2009)

  • SQL indenting rewritten: now able to indent subqueries and DDL queries; produces more readable SQL for JOINs and WHERE/HAVING clauses; improved formatting of formulas like Mid(); fixed bugs
  • Form/Report parsing rewritten: now covering form and control events, fixed parsing of sub forms/reports
  • Macro parsing rewritten: now producing human readable macro definitions; aligned parsing of TransferXXX actions; now covering many more macro actions
  • Code parsing rewritten: switched from brute force to real code parsing (avoiding false positives and allowing to detect missing objects in code); now handling procedures as individual objects ( allows to find code-to-code and event-to-code links)
  • GUI: added feedback button to main form; allows now to seed tree view with various predefined object lists (including missing/unused objects); allows now to change settings during a refresh of the dependency data
  • Object structure: introduced SQL object for SQL statements in RecordSources, RowSources and VBA code; introduced Parent/Child dependency type (e.g. a control is a child of a form, a procedure is a child of a code module etc.)
  • Error handling: Added error handling code and an error form to simplify bug reporting
  • Other fixes: Now excluding temporary table (starting with ~tmp) from analysis and many, many more ...

0.8.6 (01-Oct-2008)

  • Retrieving the field list for tables is now optional (may take an awful long time with a remote backend DB)
  • SQL formatting: PARAMETER queries now formatted correctly
  • DB Object Form: Added a back button to jump to previous object
  • Parsing: Better support for handwritten action queries without table qualifier (e.g. UPDATE Table SET Field="Content")
  • Analysis Form: Now showing the object name currently analysing (may help to identify problem if analysis got stuck)
  • Some minor improvements and bug fixing

0.8.5 (03-Jul-2008)

  • Added support for Reports
  • Added support for dependencies via HyperlinkSubAddress property of Command Button, Image and Label controls
  • Improved "special searches" (restructured, new searches for all objects)
  • Change: better icon for missing objects
  • Fix: now indenting CrossTab queries correctly
  • Fix: subform reading now works correctly
  • Fix: fixed error in parsing of update queries if target is a query
  • Fix: reporting links via RowSources of Listboxes and Comboboxes only if there is a Rowsource defined
  • Fix: replaced db.name with ExpandShare(db.name) in "read code modules" to avoid issues with network shares
  • Fixed several other minor bugs

0.8.0 (20-Mar-2008)

  • Query analysis: now parses dependencies of DDL queries
  • Macro parsing: fixed parsing of TransferText, TransferSpreadsheet, added coverage for OpenForm
  • Table reading: now determines the table type (plain, linked, ODBC) and lists connection strings for ODBC links; now reporting unreachable linked tables; now reads and analyzes field lookups in table definitions; improved field list for tables
  • TreeView: now special icons for PassThrough queries, DDL queries, linked tables and ODBC tables
  • GUI: now remembers form sizes and positions
  • Detail Form: implemented search in content (also from context menu of dependencies list)
  • lots of polishing (GUI and code)
  • killed a bunch of bugs

0.7.1 (02-Feb-2008)

  • removed an unnecessary reference
  • replaced the rich text box with the non-ActiveX control from Stephen Lebans to get rid of a problematic reference to the ActiveX RichTextBox control
  • fixed error with very large code modules

0.7.0 (14-Jan-2008)
First published version