Find differences between Microsoft Access databases and objects with Total Access Detective

Microsoft Access Object and Database Comparisons

Detect differences between Microsoft Access databases, object designs and data with Total Access Detective

Compare and Find Microsoft Access Query Differences

Total Access Detective performs detailed comparisons between two queries to tell you exactly what's different. Compare two queries in one database or identically named queries in two databases (MDB, ADP, or ACCDB formats).

Query Differences Detected

Total Access Detective makes it easy to find changes to your queries:

Query Properties (SQL, description, create and modified dates, etc.)
Fields (for SELECT queries)
- Field Names in one query but not in the other
- Field Type, Size, and other properties for identically named fields
Parameters in one query but not in the other
Data
- Record differences via sequential search
- If the first field is treated as the primary field, records in one table and not in the other (new or deleted records), and modified records

Options for Comparing Microsoft Access Queries

When comparing two queries, you can compare the object (query design) and/or data:

Visit Finding Data Differences Between Two Queries to learn more about comparing records and the advanced options for comparing queries with different fields.

Query Comparison Results

If you choose Object and Data, the results are displayed in a form with three tabs:

Object: field, property, parameters, and other design differences
Data: summary of new, deleted, and modified records
Modified Fields: for modified records, its different field values

Microsoft Access Query Comparison Showing Field, Parameter and Property Differences

Design Differences Between Two Queries

See fields and parameters defined in one query but not the other and property differences

Fields and Parameters in One Query but Not the Other

Filter to just see the fields and parameters defined in one query but not the other (could be added, deleted or renamed)

Microsoft Access Query Record Comparison, Summary of Field by Field Differences

Data Differences Between Two Queries

For queries with matching fields, records can be compared to find new and modified records

Microsoft Access Query Record Comparison, Field by Field Differences

Field Differences for Modified Records Between Two Queries

For records with different data, see the modified values for each field in side-by-side columns

For additional information on comparing data and the many options Total Access Detective offers, visit Compare Records (data) Between Microsoft Access Tables and Queries

Reports for Query Design and Data Differences

Reports are available for:

The list of query property and design differences
Records that are new, deleted or modified
Field differences for Modified records
Field names that were compared to each other
By default, the field names are identical but if you chose to compare by field order, these may be different.

Sample Reports