The table below describes the comparisons performed for each type of object in the order that AccessDiff processes them.
Feature | Description |
Compare Forms | All visual elements of the form are compared. The code module if any is compared. By default, AccessDiff automatically ignores any white space differences. |
Compare Reports | All visual elements of the report are compared. The code module if any is compared. By default, AccessDiff automatically ignores any white space differences. |
Compare Macros | All properties and commands of the macro are compared. |
Compare Modules | The full text of the module is compared. By default, AccessDiff automatically ignores any white space differences. |
Compare References | Detects broken references. Detects version differences. Detects 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.Detects column property differences. Detects table index differences. |
Compare Queries | The SQL between the source and destination databases are compared. By default, AccessDiff automatically ignores any white space differences. |
Compare Records | Detects all record differences based on the primary key. If there is no primary key defined, there will be a prompt to enter the natural key. |
Stored Procedures | Compares SQL Server Stored Procedures for ADP (Access Database Projects) |
Functions | Compares SQL Server Functions for ADP (Access Database Projects) |
Views | Compares SQL Server Views for ADP (Access Database Projects) |