Specify Database Comparison Options

A variety of comparison options are available:

Compare Table Data: Perform data comparison for the selected tables. A set of Data Options are available to control how fields are compared and how the results are presented.

Compare Field Properties: Compare all the field properties in the selected tables and queries (rather than just type and size).

Compare References: Compare VBA library references.

Compare Permissions: Compare security permission settings.

Compare Form Modules and Compare Report Modules: Decide if code behind forms and reports are compared.

Text Options: For modules and macro lines, choose whether to ignore differences with blank lines, indentations, case and comment differences are flagged. Also set how Total Access Detective determines when blocks of code are added or deleted.