FMS Home FMS Software Development Team Blog FMS Facebook Page FMS Twitter
Jump: Search:

Total Access Detective

Detective Info:

Why Detective?

Product Reviews 

"Total Access Detective is well worth every penny, it will quickly pay for itself through savings in time and effort."

Tom Cryan, Denver Access User Group product review

More Reviews

Additional Info:

 

 
Find differences between Microsoft Access databases and objects with Total Access DetectiveMicrosoft Access Object and Database ComparisonsDetect 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).

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

Visit finding the data differences between two queries to learn more about comparing records and the advanced options for comparing queries with different fields.

Comparing Microsoft Access Queries

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

Compare Microsoft Access table properties, data, or both

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

Property Differences Between Two Queries

Microsoft Access Query Property Differences
Example of Query Comparison Showing Property Differences

Data Differences Between Two Queries

Microsoft Access Query Data comparison for record differences
Example of Data Comparison Showing New and Modified Records

Field Differences for Modified Records Between Two Queries

Microsoft Access Query Differences Between Modified Records
Display of the Modified Field Values in Modified Records

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.

Reports can be printed, previewed, opened in Report View, or exported to a variety of formats such as PDF, HTML, snapshot, text, etc.

Total Access Detective Home

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright FMS, Inc., Vienna, Virginia
Celebrating our 27th Year of Software Excellence