Total Access Detective finds the differences between any two objects in one Microsoft Access database, including fields, controls, properties, macro lines, module code, and data.
Does Total Access Detective offer the ability to update a Microsoft Access database based on the differences it detects after comparing it to another database?
No, Total Access Detective determines what's different between two Microsoft Access databases but does not combine the differences automatically. It cannot determine which modifications should be kept and how to combine changes within modified objects. You as the developer need to determine what needs to be modified based on the differences reported.
Combining the Objects
Create a copy of the database that most resembles your "final" merged copy, then update it with the changes from the other database based on what Total Access Detective found.
Easy: New objects and Replacements
- Import any new objects that doesn't already exist
- To replace an existing object, delete it then import the replacement object
More Challenging: Objects that are Partially Updated
There may be some objects with a combination of changes that need to be preserved. In these situations, you can't just replace one with one or the other.
- Manually update your new object with the portions of the old object you want to preserve. This may involve:
- Setting object properties
- Adding/deleting fields on tables and queries
- Adding/deleting controls on forms and reports
- Adding/deleting groupings on reports
- For macros and modules, there may be portions of code that you want to add or delete within each object
Combining the Data
For table data, assuming the structure of the tables were not modified, Total Access Detective provides a feature that enables you to easily combine the data from two tables by specifying which table’s records should be kept. Visit Merge Data From Two Microsoft Access Tables into a New Table for details.