Compare provides a powerful facility for comparing two sets of related data, as described in this topic.
The following steps are used to perform the Compare Process:
Many options are provided for defining the sources of the data. You can use a new or existing Access Definition and Compare will extract the data as part of the process. Alternatively, you can use the data previously extracted and stored in an Extract File on disk. Data to be compared can reside in a single table or in multiple related tables.
The results of the comparison are stored in a Compare File. You can browse the results online using Compare, or generate a report and print or store the report in a sequential file. A variety of report options enable you to control the contents.
The remainder of this section discusses the processing flow and describes how to perform the Compare Process for a single pair of tables or for two sets of related data residing in multiple tables. It also includes information on browsing the results and generating reports.