Access Database Analyzer Pro - 3: View Analysis Results

This is the third in a series of videos about my new Access Database Analyzer and Viewer Pro application which is scheduled for release early in September 2023. It is designed to analyze a wide range of items in any external Access database without opening it directly. This video explains how to use/interpret the results obtained from analyzing selected Access databases. For more details, see my web article https://www.isladogs.co.uk/database-analyzer-pro/ A free evaluation version is available so you can try out its features before purchase TIMES: 0:00 Introduction 0:17 Main form with analysis results from video 2 0:54 Object info - database objects sorted by type with additional info about subtype/default view/hidden objects/system objects and object size in kilobytes 2:52 Save any object as text file e.g. for importing into another database 5:34 Object Metadata - date created / date last modified & (optional) object description 5:58 Table analysis - table type (local/linked/system). View table design & data. Number of fields / records & table size 7:27 Field analysis - field names & datatypes; primary key field/index info/field size. Are zero length strings allowed? Is field required? 8:50 Relationships info - table & field names / relationship type. Is Referential integrity enforced? Cascade update / delete? 9:41 Query info - none in selected database - discussed later for a different database 9:45 VBA code modules & procedures- procedure type & code lines. 10:26 View VBA code for any procedure or code module. Color formatting used. View code in report or copy to clipboard 12:51 Object dependencies - list of objects with count ob dependencies and dependant objects. Dependency details as report 14:03 VBA references - description / name / version. Broken references identified 15:07 Database properties - name / type / value 15:37 Save analysis for future use - 2 methods available 17:20 Another analysis run on a different database in 'real time' with linked tables & queries showing use of progress bars / estimated time left etc 19:18 Relationship - show relationships diagram in external database 20:12 Query info - query type / last saved view / flags value / hidden property / number of foelds / records/ parameters. View query in design / datasheet / SQL view. Copy query SQL to clipboard 22:41 Additional table info including the data source for linked tables 24:23 Use analyzer to collect data on client databases to determine priorities for action