About AccessDiff

Easily compare Access databases.

AccessDiff compares objects with the same name from two Access databases. It also detects missing objects in either the source or destination. Records are compared based on the primary key and if there is no primary key for a table, the comparison is performed on the Natural Key. After the database comparison is performed, the differences can be exported into several different formats.

AccessDiff Features

  • Compare Toolbars and Menu Bars - All custom toolbars and menu bars are compared. The properties of individual command buttons are also compared.
  • Compare Forms - All visual elements of the form are compared. AccessDiff automatically ignores any white space differences. Missing tables and queries are automatically detected and logged.
  • Compare Reports - All visual elements of the report are compared. AccessDiff automatically ignores any white space differences. Missing tables and queries are automatically detected and logged.
  • Compare Macros - All properties and commands of the macro are compared.
  • Compare Modules - The full text of the module is compared. AccessDiff automatically ignores any white space differences.
  • Compare References - Detects broken references, version differences and missing references between the source and destination databases.
  • Compare Data Access Pages - All elements are compared.
  • Compare Table Relationships - All relationships between tables are compared. All properties of the relationships are compared.
  • Compare Table/Field Definitions - Compares the existence or non-existence of tables between the source and destination databases and all field definitions.
  • Compare Queries - Source and destination SQL is compared. AccessDiff automatically ignores any white space differences. Missing tables and subqueries are automatically detected and logged.
  • Compare Records - Detects all record differences based on the primary key. If there is no primary key for a table, the comparison is performed on the user chosen Natural Key.
  • Compare ADP (Access Database Projects) - Compares SQL Server Tables, Stored Procedures, Functions and Views.
  • Compare Text Files - Performs intelligent code comparison for VBA, VB, VB.NET, TSQL, C#, Java, Javascript, and PHP.
  • Compare Snippets - Compares two code snipets.
  • Word Difference Highlighting - Highlights word differences during code comparison.
  • Startup Forms - Supports startup forms and AutoExec macros.
  • Table Data Differences - Table data difference report.
  • Command Line Interface - Compare two databases with the default options and export a report.